PgsqlSqlUtil::PgsqlDatabase Class Reference

provides the PostgreSQL-specific implementation of the AbstractDatabase interface More...

Inherits SqlUtil::AbstractDatabase.

Public Member Methods
list< string >	listMaterializedViews ()
	returns a list of string materialized view names in the database
list< string >	listTypes ()
	returns a list of string type names in the database
ListIterator	materializedViewIterator ()
	returns an iterator listing the string materialized view names in the database
ListIterator	typeIterator ()
	returns an iterator listing the string type names in the database

Static Public Member Methods
static string	getCreateSql (list l)
	returns a string that can be used to create the schema in the database
static auto	tryExecArgs (AbstractDatasource ds, string sql, *softlist< auto > args)
	tries to execute a command so that if an error occurs the current transaction status is not lost
static auto	tryExecRaw (AbstractDatasource ds, string sql)
	tries to execute a command so that if an error occurs the current transaction status is not lost

Public Attributes
const	PgsqlReclaimSpaceOptions = ...
	Options for reclaimSpace()
const	PgsqlReservedWords = ...
	hash (set) of reserved words
const	PgsqlSchemaDescriptionOptions = ...
	PostgreSQL-specific schema description keys.

Private Member Methods
	computeStatisticsImpl (*hash options)
	compute statistics implementation. See SqlUtil::AbstractDatabase::computeStatistics()
string	getCreateSqlImpl (list l)
	returns a string that can be used to create the schema in the database
softint	getCurrentSequenceValueImpl (string name)
	returns the last value issued for the given sequence in the current session
softint	getNextSequenceValueImpl (string name)
	returns the next value in the given sequence
int	getPhysicalSizeImpl ()
	SqlUtil::AbstractDatabase.getPhysicalSize()
hash	getReclaimSpaceOptions ()
	returns driver-specific options to the base abstract class
hash	getSchemaDescriptionOptions ()
	returns driver-specific options to the base abstract class
list< string >	listFunctionsImpl ()
	returns a list of string function names in the database More...
list< string >	listProceduresImpl ()
	since PostgreSQL only supports functions, this method is identical to listFunctionsImpl() More...
list< string >	listTablesImpl ()
	returns a list of string table names in the database
bool	rebuildIndexImpl (string name, *hash options)
	rebuild index implementation. See SqlUtil::AbstractDatabase::rebuildIndex()
	reclaimSpaceImpl (*hash options)
	reclaim space implementation. See SqlUtil::AbstractDatabase::reclaimSpace()
bool	supportsPackagesImpl ()
	returns True if the database supports packages
bool	supportsSequencesImpl ()
	returns True if the database supports sequences
bool	supportsTypesImpl ()
	returns True if the database supports named types
auto	tryExecArgsImpl (string sql, *softlist< auto > args)
	tries to execute a command so that if an error occurs the current transaction status is not lost
auto	tryExecRawImpl (string sql, *softlist< auto > args)
	tries to execute a command so that if an error occurs the current transaction status is not lost

Detailed Description

provides the PostgreSQL-specific implementation of the AbstractDatabase interface

Member Function Documentation

listFunctionsImpl()

list<string> PgsqlSqlUtil::PgsqlDatabase::listFunctionsImpl ( )

private

returns a list of string function names in the database

The function names will include arguments in parentheses after the names

Returns

a list of string function names in the database

listProceduresImpl()

list<string> PgsqlSqlUtil::PgsqlDatabase::listProceduresImpl ( )

private

since PostgreSQL only supports functions, this method is identical to listFunctionsImpl()

See also

listFunctionsImpl()