Method Sql.pgsql()->list_fields()
- Method list_fields
final 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.