db=# \d item;
            Table "public.item"
 Column  |  Type   |       Modifiers
---------+---------+------------------------
 id      | text    | not null
 name    | text    | not null
 note    | text    |
 active  | boolean | not null default true
 pid     | text    |
 isgroup | boolean | not null default false
 agroup  | boolean | not null default false
Indexes:
    "item_pkey" PRIMARY KEY, btree (id)
    "item_pid_idx" hash (pid)
Foreign-key constraints:
    "item_self_fk" FOREIGN KEY (pid) REFERENCES item(id) ON UPDATE CASCADE ON DELETE CASCADE

db=# select c.oid from pg_class c where relnamespace =  2200  and relkind = 'r' and relname = 'item';
  oid
-------
  19959 
( 1  row)

db=# select attname from pg_attribute where attrelid =  19959  and not attisdropped and attnum >  0  order by attnum;
 attname
---------
 id
 name
 note
 active
 pid
 isgroup
 agroup
( 7  rows)