sqlobject.postgres.pgconnection module

class sqlobject.postgres.pgconnection.ErrorMessage

Bases: str

sqlobject.postgres.pgconnection.OdbcBinaryConverter(value, db)

sqlobject.postgres.pgconnection.PostgresBinaryConverter(value, db)

class sqlobject.postgres.pgconnection.PostgresConnection(dsn=None, host=None, port=None, db=None, user=None, password=None, **kw)

Bases: sqlobject.dbconnection.DBAPI

addColumn(tableName, column)

columnsFromSchema(tableName, soClass)

createColumn(soClass, col)

createEmptyDatabase()

createIDColumn(soClass)

createIndexSQL(soClass, index)

createReferenceConstraint(soClass, col)

dbName = 'postgres'

defaultFromSchema(colClass, defaultstr)

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

delColumn(sqlmeta, column)

dropDatabase()

dropTable(tableName, cascade=False)

guessClass(t)

joinSQLType(join)

listDatabases()

listTables()

makeConnection()

odbc_keywords = ('Server', 'Port', 'UID', 'Password', 'Database')

schemes = ['postgres', 'postgresql']

supportTransactions = True

tableExists(tableName)

sqlobject.postgres.pgconnection.PsycoBinaryConverter(value, db)

sqlobject.postgres.pgconnection.escape_bytea(value)