AO Logo
 
  
  
  
PostgreSQL Databases
AO
AO Industries, Inc.
Application Infrastructure ProviderApplication Infrastructure Provider
Sign UpWhat's NewClient AreaContact UsSite Map
 
your location:   home page ··· aoserv platform ··· software components ··· aoserv client ··· tables ··· table definitions ··· postgresql databases

TABLE NAME

postgres_databases

DESCRIPTION

The postgres_databases table stores the information about each PostgreSQL database in the system.

COLUMNS

columntypenulluniquereferencesreferenced_bysince_versiondescription
pkeypkeyfalsetrue1.0a100a unique, generated primary key
namepostgres_database_namefalsefalse1.80.0the name of the database
postgres_serverfkeyfalsefalsepostgres_servers.bind1.0a100the pkey of the PostgreSQL server
datdbafkeyfalsefalsepostgres_server_users.pkey1.0a100the datdba for the database
encodingfkeyfalsefalsepostgres_encodings.pkey1.0a100the pkey of the encoding system used for the database
is_templatebooleanfalsefalse1.0a100if true, this database is a template
allow_connbooleanfalsefalse1.0a100if true, this database is accepting connections
enable_postgisbooleanfalsefalse1.27indicates PostGIS is enabled on this database