Sql.pgsql()->list_dbs()

Sql.pgsql()->list_tables()

Method Sql.pgsql()->list_fields()

Method list_fields

array(mapping(string:mixed)) list_fields(void|string table, void|string glob)

Returns

A mapping, indexed on the column name, of mappings describing the attributes of a table of the current database. The currently defined fields are:

"schema" : string Schema the table belongs to "table" : string Name of the table "kind" : string Type of table "owner" : string Tableowner "rowcount" : int Estimated rowcount of the table "datasize" : int Estimated total datasize of the table in bytes "indexsize" : int Estimated total indexsize of the table in bytes "name" : string Name of the column "type" : string A textual description of the internal (to the server) column type-name "typeoid" : int The OID of the internal (to the server) column type "length" : string Size of the columndatatype "default" : mixed Default value for the column "is_shared" : int If the table has any indices "has_index" : int "has_primarykey" : int If the table has a primary key

Parameter glob

If specified, list only the tables with matching names. Setting it to * will include system columns in the list.