PostgresBuilder

# createDatabase ( $name ) : bool

Create a database in the schema.

Parameters

• $name string

# dropDatabaseIfExists ( $name ) : bool

Drop a database from the schema if the database exists.

Parameters

• $name string

# hasTable ( $table ) : bool

Determine if the given table exists.

Parameters

• $table string

# dropAllTables ( ) : void

Drop all tables from the database.

# dropAllViews ( ) : void

Drop all views from the database.

# dropAllTypes ( ) : void

Drop all types from the database.

# getAllTables ( ) : array

Get all of the table names for the database.

# getAllViews ( ) : array

Get all of the view names for the database.

# getAllTypes ( ) : array

Get all of the type names for the database.

# getColumnListing ( $table ) : array

Get the column listing for a given table.

Parameters

• $table string

# parseSchemaAndTable ( $reference ) : array

Parse the database object reference and extract the database, schema, and table.

Parameters

• $reference string

# parseSearchPath ( $searchPath ) : array

Parse the "search_path" configuration value into an array.

Parameters

• $searchPath string|array|null