hidden=> \d List of relations Name | Type | Owner ------------+-------+----------------- book | table | hidden class | table | hidden columnname | table | hidden kind | table | hidden kindsub | table | hidden pub | table | hidden series | table | hidden size | table | hidden (8 rows) hidden=> \d book Table "book" Attribute | Type | Modifier --------------+------------------------+-------------------- id | character(10) | not null pub | integer | not null default 0 isbn | character(10) | year | character(4) | not null month | character(2) | not null day | character(2) | not null title | character varying(128) | not null titleym | character varying(128) | not null subtitle | character varying(128) | subtitleym | character varying(128) | series | integer | default 0 page | integer | default 0 size | integer | not null default 0 coauth | character varying(128) | coauthym | character varying(128) | mainauth | character varying(128) | mainauthym | character varying(128) | editor | character varying(128) | editorym | character varying(128) | jointauth | character varying(128) | staff | text | profile | text | person | text | note | text | index | text | keyword | text | firstpubinfo | text | kind | integer | not null default 0 kindsub | integer | default 0 class | integer | not null default 0 Index: book_pkey hidden=> \d class Table "class" Attribute | Type | Modifier -----------+------------------------+---------- classid | integer | not null classname | character varying(128) | Index: class_pkey hidden=> \d columnname Table "columnname" Attribute | Type | Modifier --------------+------------------------+---------- columnnameid | integer | not null columnname | character varying(128) | columnename | character varying(128) | Index: columnname_pkey hidden=> \d kind Table "kind" Attribute | Type | Modifier -----------+------------------------+---------- kindid | integer | not null kindname | character varying(128) | kindename | character varying(128) | Index: kind_pkey hidden=> \d kindsub Table "kindsub" Attribute | Type | Modifier -----------+------------------------+-------------------- ksid | integer | not null kind | integer | not null default 0 ksname | character varying(128) | Index: kindsub_pkey hidden=> \d pub Table "pub" Attribute | Type | Modifier -----------+------------------------+---------- pubid | integer | not null pubname | character varying(128) | pubnameym | character varying(128) | Index: pub_pkey hidden=> \d series Table "series" Attribute | Type | Modifier --------------+------------------------+---------- seriesid | integer | not null seriesname | character varying(128) | seriesnameym | character varying(128) | Index: series_pkey hidden=> \d size Table "size" Attribute | Type | Modifier -----------+------------------------+---------- sizeid | integer | not null sizename | character varying(128) | Index: size_pkey