sqlobject.postgres.pgconnection module

class sqlobject.postgres.pgconnection.ErrorMessage[source]

Bases: str

sqlobject.postgres.pgconnection.OdbcBinaryConverter(value, db)[source]
sqlobject.postgres.pgconnection.PostgresBinaryConverter(value, db)[source]
class sqlobject.postgres.pgconnection.PostgresConnection(dsn=None, host=None, port=None, db=None, user=None, password=None, **kw)[source]

Bases: sqlobject.dbconnection.DBAPI

addColumn(tableName, column)[source]
columnsFromSchema(tableName, soClass)[source]
createColumn(soClass, col)[source]
createEmptyDatabase()[source]
createIDColumn(soClass)[source]
createIndexSQL(soClass, index)[source]
createReferenceConstraint(soClass, col)[source]
dbName = 'postgres'
defaultFromSchema(colClass, defaultstr)[source]

If the default can be converted to a python constant, convert it. Otherwise return is as a sqlbuilder constant.

delColumn(sqlmeta, column)[source]
dropDatabase()[source]
dropTable(tableName, cascade=False)[source]
guessClass(t)[source]
joinSQLType(join)[source]
listDatabases()[source]
listTables()[source]
makeConnection()[source]
odbc_keywords = ('Server', 'Port', 'UID', 'Password', 'Database')
schemes = ['postgres', 'postgresql']
supportTransactions = True
tableExists(tableName)[source]
sqlobject.postgres.pgconnection.PsycoBinaryConverter(value, db)[source]
sqlobject.postgres.pgconnection.escape_bytea(value)[source]