PgsqlPlatform

class PgsqlPlatform extends DefaultPlatform

Methods

	__construct(PDO $con = null) Default constructor.	from DefaultPlatform
	setConnection(PDO $con = null) Set the database connection to use for this Platform class.	from DefaultPlatform
PDO	getConnection() Returns the database connection to use for this Platform class.	from DefaultPlatform
	setGeneratorConfig(GeneratorConfigInterface $config) Sets the GeneratorConfig to use in the parsing.	from DefaultPlatform
string	getDatabaseType() Returns the short name of the database type that this platform represents.	from DefaultPlatform
	getMaxColumnNameLength()
	getNativeIdMethod()
	isNativeIdMethodAutoIncrement()	from DefaultPlatform
Domain	getDomainForType(string $propelType) Returns the db specific domain for a propelType.	from DefaultPlatform
string	getNullString($notNull)	from DefaultPlatform
	getAutoIncrement()
string	getSequenceName(Table $table) Override to provide sequence names that conform to postgres' standard when no id-method-parameter specified.
	getAddTablesDDL(Database $database)
string	getBeginDDL() Gets the requests to execute at the beginning of a DDL file	from DefaultPlatform
string	getEndDDL() Gets the requests to execute at the end of a DDL file	from DefaultPlatform
	getDropTableDDL(Table $table)
	getAddTableDDL(Table $table)
	getColumnDDL(Column $col)
string	getColumnDefaultValueDDL(Column $col) Returns the SQL for the default value of a Column object	from DefaultPlatform
string	getColumnListDDL($columns, $delimiter = ',') Creates a delimiter-delimited string list of column names, quoted using quoteIdentifier().	from DefaultPlatform
	getPrimaryKeyName(Table $table)
string	getPrimaryKeyDDL(Table $table) Returns the SQL for the primary key of a Table object	from DefaultPlatform
string	getDropPrimaryKeyDDL(Table $table) Builds the DDL SQL to drop the primary key of a table.	from DefaultPlatform
string	getAddPrimaryKeyDDL(Table $table) Builds the DDL SQL to add the primary key of a table.	from DefaultPlatform
string	getAddIndicesDDL(Table $table) Builds the DDL SQL to add the indices of a table.	from DefaultPlatform
string	getAddIndexDDL(Index $index) Builds the DDL SQL to add an Index.	from DefaultPlatform
string	getDropIndexDDL(Index $index) Overrides the implementation from DefaultPlatform
string	getIndexDDL(Index $index) Builds the DDL SQL for an Index object.	from DefaultPlatform
	getUniqueDDL(Unique $unique)
string	getAddForeignKeysDDL(Table $table) Builds the DDL SQL to add the foreign keys of a table.	from DefaultPlatform
string	getAddForeignKeyDDL(ForeignKey $fk) Builds the DDL SQL to add a foreign key.	from DefaultPlatform
string	getDropForeignKeyDDL(ForeignKey $fk) Builds the DDL SQL to drop a foreign key.	from DefaultPlatform
string	getForeignKeyDDL(ForeignKey $fk) Builds the DDL SQL for a ForeignKey object.	from DefaultPlatform
	getCommentLineDDL($comment)	from DefaultPlatform
	getCommentBlockDDL($comment)	from DefaultPlatform
string	getModifyDatabaseDDL(PropelDatabaseDiff $databaseDiff) Builds the DDL SQL to modify a database based on a PropelDatabaseDiff instance	from DefaultPlatform
string	getRenameTableDDL($fromTableName, $toTableName) Builds the DDL SQL to rename a table	from DefaultPlatform
string	getModifyTableDDL(PropelTableDiff $tableDiff) Builds the DDL SQL to alter a table based on a PropelTableDiff instance	from DefaultPlatform
string	getModifyTableColumnsDDL(PropelTableDiff $tableDiff) Builds the DDL SQL to alter a table based on a PropelTableDiff instance	from DefaultPlatform
string	getModifyTablePrimaryKeyDDL(PropelTableDiff $tableDiff) Builds the DDL SQL to alter a table's primary key based on a PropelTableDiff instance	from DefaultPlatform
string	getModifyTableIndicesDDL(PropelTableDiff $tableDiff) Builds the DDL SQL to alter a table's indices based on a PropelTableDiff instance	from DefaultPlatform
string	getModifyTableForeignKeysDDL(PropelTableDiff $tableDiff) Builds the DDL SQL to alter a table's foreign keys based on a PropelTableDiff instance	from DefaultPlatform
string	getRemoveColumnDDL(Column $column) Builds the DDL SQL to remove a column	from DefaultPlatform
string	getRenameColumnDDL($fromColumn, $toColumn) Builds the DDL SQL to rename a column	from DefaultPlatform
string	getModifyColumnDDL(PropelColumnDiff $columnDiff) Overrides the implementation from DefaultPlatform
string	getModifyColumnsDDL($columnDiffs) Overrides the implementation from DefaultPlatform
string	getAddColumnDDL(Column $column) Builds the DDL SQL to remove a column	from DefaultPlatform
string	getAddColumnsDDL($columns) Overrides the implementation from DefaultPlatform
	hasSize($sqlType)
boolean	hasScale(string $sqlType) Returns if the RDBMS-specific SQL type has a scale attribute.	from DefaultPlatform
string	quote(string $text) Quote and escape needed characters in the string for unerlying RDBMS.	from DefaultPlatform
string	quoteIdentifier(string $text) Quotes identifiers used in database SQL.	from DefaultPlatform
	setIdentifierQuoting($enabled = true)	from DefaultPlatform
	getIdentifierQuoting()	from DefaultPlatform
	supportsNativeDeleteTrigger()
boolean	supportsInsertNullPk() Whether RDBMS supports INSERT null values in autoincremented primary keys	from DefaultPlatform
	hasStreamBlobImpl()
	supportsSchemas()
	supportsMigrations()	from DefaultPlatform
	supportsVarcharWithoutSize()
	getBooleanString($b)
	getPhpArrayString($stringValue)	from DefaultPlatform
string	getTimestampFormatter() Gets the preferred timestamp formatter for setting date/time values.	from DefaultPlatform
string	getTimeFormatter() Gets the preferred time formatter for setting date/time values.	from DefaultPlatform
string	getDateFormatter() Gets the preferred date formatter for setting date/time values.	from DefaultPlatform
	getColumnBindingPHP($column, $identifier, $columnValueAccessor, $tab = ' ') Get the PHP snippet for binding a value to a column.	from DefaultPlatform
	getIdentifierPhp($columnValueMutator, $connectionVariableName = '$con', $sequenceName = '', $tab = ' ') Get the PHP snippet for getting a Pk from the database.
string	disconnectedEscapeText(string $text) Escape the string for RDBMS.
	getAddSchemasDDL(Database $database)
	getAddSchemaDDL(Table $table)
	getUseSchemaDDL(Table $table)
	getResetSchemaDDL(Table $table)

Details

in DefaultPlatform at line 48

public __construct(PDO $con = null)

in DefaultPlatform at line 58

public setConnection(PDO $con = null)

in DefaultPlatform at line 67

public PDO getConnection()

in DefaultPlatform at line 77

public setGeneratorConfig(GeneratorConfigInterface $config)

in DefaultPlatform at line 128

public string getDatabaseType()

at line 59

public getMaxColumnNameLength()

at line 49

public getNativeIdMethod()

in DefaultPlatform at line 156

public isNativeIdMethodAutoIncrement()

in DefaultPlatform at line 168

public Domain getDomainForType(string $propelType)

in DefaultPlatform at line 181

public string getNullString($notNull)

at line 54

public getAutoIncrement()

at line 100

public string getSequenceName(Table $table)

at line 201

public getAddTablesDDL(Database $database)

in DefaultPlatform at line 254

public string getBeginDDL()

in DefaultPlatform at line 263

public string getEndDDL()

at line 292

public getDropTableDDL(Table $table)

at line 219

public getAddTableDDL(Table $table)

at line 313

public getColumnDDL(Column $col)

in DefaultPlatform at line 354

public string getColumnDefaultValueDDL(Column $col)

in DefaultPlatform at line 398

public string getColumnListDDL($columns, $delimiter = ',')

at line 306

public getPrimaryKeyName(Table $table)

in DefaultPlatform at line 426

public string getPrimaryKeyDDL(Table $table)

in DefaultPlatform at line 439

public string getDropPrimaryKeyDDL(Table $table)

in DefaultPlatform at line 457

public string getAddPrimaryKeyDDL(Table $table)

in DefaultPlatform at line 475

public string getAddIndicesDDL(Table $table)

in DefaultPlatform at line 491

public string getAddIndexDDL(Index $index)

at line 470

public string getDropIndexDDL(Index $index)

in DefaultPlatform at line 528

public string getIndexDDL(Index $index)

at line 341

public getUniqueDDL(Unique $unique)

in DefaultPlatform at line 554

public string getAddForeignKeysDDL(Table $table)

in DefaultPlatform at line 570

public string getAddForeignKeyDDL(ForeignKey $fk)

in DefaultPlatform at line 591

public string getDropForeignKeyDDL(ForeignKey $fk)

in DefaultPlatform at line 610

public string getForeignKeyDDL(ForeignKey $fk)

in DefaultPlatform at line 636

public getCommentLineDDL($comment)

in DefaultPlatform at line 644

public getCommentBlockDDL($comment)

in DefaultPlatform at line 661

public string getModifyDatabaseDDL(PropelDatabaseDiff $databaseDiff)

in DefaultPlatform at line 695

public string getRenameTableDDL($fromTableName, $toTableName)

in DefaultPlatform at line 713

public string getModifyTableDDL(PropelTableDiff $tableDiff)

in DefaultPlatform at line 778

public string getModifyTableColumnsDDL(PropelTableDiff $tableDiff)

in DefaultPlatform at line 807

public string getModifyTablePrimaryKeyDDL(PropelTableDiff $tableDiff)

in DefaultPlatform at line 825

public string getModifyTableIndicesDDL(PropelTableDiff $tableDiff)

in DefaultPlatform at line 852

public string getModifyTableForeignKeysDDL(PropelTableDiff $tableDiff)

in DefaultPlatform at line 878

public string getRemoveColumnDDL(Column $column)

in DefaultPlatform at line 894

public string getRenameColumnDDL($fromColumn, $toColumn)

at line 379

public string getModifyColumnDDL(PropelColumnDiff $columnDiff)

at line 436

public string getModifyColumnsDDL($columnDiffs)

in DefaultPlatform at line 963

public string getAddColumnDDL(Column $column)

at line 453

public string getAddColumnsDDL($columns)

at line 357

public hasSize($sqlType)

in DefaultPlatform at line 1024

public boolean hasScale(string $sqlType)

in DefaultPlatform at line 1034

public string quote(string $text)

in DefaultPlatform at line 1062

public string quoteIdentifier(string $text)

in DefaultPlatform at line 1067

public setIdentifierQuoting($enabled = true)

in DefaultPlatform at line 1072

public getIdentifierQuoting()

at line 87

public supportsNativeDeleteTrigger()

in DefaultPlatform at line 1090

public boolean supportsInsertNullPk()

at line 362

public hasStreamBlobImpl()

at line 352

public supportsSchemas()

in DefaultPlatform at line 1115

public supportsMigrations()

at line 367

public supportsVarcharWithoutSize()

at line 78

public getBooleanString($b)

in DefaultPlatform at line 1144

public getPhpArrayString($stringValue)

in DefaultPlatform at line 1169

public string getTimestampFormatter()

in DefaultPlatform at line 1178

public string getTimeFormatter()

in DefaultPlatform at line 1187

public string getDateFormatter()

in DefaultPlatform at line 1197

public getColumnBindingPHP($column, $identifier, $columnValueAccessor, $tab = ' ')

at line 491

public getIdentifierPhp($columnValueMutator, $connectionVariableName = '$con', $sequenceName = '', $tab = ' ')

at line 69

public string disconnectedEscapeText(string $text)

at line 152

public getAddSchemasDDL(Database $database)

at line 167

public getAddSchemaDDL(Table $table)

at line 179

public getUseSchemaDDL(Table $table)

at line 191

public getResetSchemaDDL(Table $table)