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(GeneratorConfig $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()
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()
	getBooleanString($b)
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
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(GeneratorConfig $config)

in DefaultPlatform at line 127

public string getDatabaseType()

at line 59

public getMaxColumnNameLength()

at line 49

public getNativeIdMethod()

in DefaultPlatform at line 160

public Domain getDomainForType(string $propelType)

in DefaultPlatform at line 172

public string getNullString($notNull)

at line 54

public getAutoIncrement()

at line 99

public string getSequenceName(Table $table)

at line 195

public getAddTablesDDL(Database $database)

in DefaultPlatform at line 244

public string getBeginDDL()

in DefaultPlatform at line 253

public string getEndDDL()

at line 284

public getDropTableDDL(Table $table)

at line 212

public getAddTableDDL(Table $table)

at line 303

public getColumnDDL(Column $col)

in DefaultPlatform at line 340

public string getColumnDefaultValueDDL(Column $col)

in DefaultPlatform at line 376

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

at line 297

public getPrimaryKeyName(Table $table)

in DefaultPlatform at line 402

public string getPrimaryKeyDDL(Table $table)

in DefaultPlatform at line 415

public string getDropPrimaryKeyDDL(Table $table)

in DefaultPlatform at line 432

public string getAddPrimaryKeyDDL(Table $table)

in DefaultPlatform at line 449

public string getAddIndicesDDL(Table $table)

in DefaultPlatform at line 464

public string getAddIndexDDL(Index $index)

at line 448

public string getDropIndexDDL(Index $index)

in DefaultPlatform at line 499

public string getIndexDDL(Index $index)

at line 331

public getUniqueDDL(Unique $unique)

in DefaultPlatform at line 525

public string getAddForeignKeysDDL(Table $table)

in DefaultPlatform at line 540

public string getAddForeignKeyDDL(ForeignKey $fk)

in DefaultPlatform at line 560

public string getDropForeignKeyDDL(ForeignKey $fk)

in DefaultPlatform at line 578

public string getForeignKeyDDL(ForeignKey $fk)

in DefaultPlatform at line 604

public getCommentLineDDL($comment)

in DefaultPlatform at line 611

public getCommentBlockDDL($comment)

in DefaultPlatform at line 627

public string getModifyDatabaseDDL(PropelDatabaseDiff $databaseDiff)

in DefaultPlatform at line 658

public string getRenameTableDDL($fromTableName, $toTableName)

in DefaultPlatform at line 675

public string getModifyTableDDL(PropelTableDiff $tableDiff)

in DefaultPlatform at line 740

public string getModifyTableColumnsDDL(PropelTableDiff $tableDiff)

in DefaultPlatform at line 769

public string getModifyTablePrimaryKeyDDL(PropelTableDiff $tableDiff)

in DefaultPlatform at line 787

public string getModifyTableIndicesDDL(PropelTableDiff $tableDiff)

in DefaultPlatform at line 814

public string getModifyTableForeignKeysDDL(PropelTableDiff $tableDiff)

in DefaultPlatform at line 840

public string getRemoveColumnDDL(Column $column)

in DefaultPlatform at line 855

public string getRenameColumnDDL($fromColumn, $toColumn)

at line 364

public string getModifyColumnDDL(PropelColumnDiff $columnDiff)

at line 416

public string getModifyColumnsDDL($columnDiffs)

in DefaultPlatform at line 921

public string getAddColumnDDL(Column $column)

at line 432

public string getAddColumnsDDL($columns)

at line 347

public hasSize($sqlType)

in DefaultPlatform at line 980

public boolean hasScale(string $sqlType)

in DefaultPlatform at line 990

public string quote(string $text)

in DefaultPlatform at line 1018

public string quoteIdentifier(string $text)

in DefaultPlatform at line 1023

public setIdentifierQuoting($enabled = true)

in DefaultPlatform at line 1028

public getIdentifierQuoting()

at line 86

public supportsNativeDeleteTrigger()

in DefaultPlatform at line 1046

public boolean supportsInsertNullPk()

at line 352

public hasStreamBlobImpl()

at line 342

public supportsSchemas()

at line 78

public getBooleanString($b)

in DefaultPlatform at line 1090

public string getTimestampFormatter()

in DefaultPlatform at line 1099

public string getTimeFormatter()

in DefaultPlatform at line 1108

public string getDateFormatter()

at line 69

public string disconnectedEscapeText(string $text)

at line 148

public getAddSchemasDDL(Database $database)

at line 162

public getAddSchemaDDL(Table $table)

at line 174

public getUseSchemaDDL(Table $table)

at line 185

public getResetSchemaDDL(Table $table)