Qore PgsqlSqlUtil Module Reference  1.6
PgsqlSqlUtil::PgsqlDatabase Class Reference

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

Inherits SqlUtil::AbstractDatabase.

Public Member Methods

list< stringlistMaterializedViews ()
 returns a list of string materialized view names in the database
 
list< stringlistTypes ()
 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< stringlistFunctionsImpl ()
 returns a list of string function names in the database More...
 
list< stringlistProceduresImpl ()
 since PostgreSQL only supports functions, this method is identical to listFunctionsImpl() More...
 
list< stringlistTablesImpl ()
 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()