Pike v8.1 release 6

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.