                                    Table "public.multicom"
    Column     |           Type           |                      Modifiers                      
---------------+--------------------------+-----------------------------------------------------
 id            | integer                  | not null default nextval('"multicom_id_seq"'::text)
 zulieferer    | character varying(3)     | not null
 prioritaet    | integer                  | not null
 rubrik        | character varying(20)    | not null
 kategorie     | character varying(3)     | not null
 datum         | timestamp with time zone | not null
 kennung       | character varying(40)    | not null
 dachzeile     | character varying(255)   | 
 ueberschrift  | character varying(255)   | not null
 unterzeile    | character varying(120)   | 
 autor         | character varying(255)   | 
 zwischentitel | character varying(255)   | 
 vorspann      | text                     | 
 kurztext      | character varying(150)   | not null
 gueltig_bis   | timestamp with time zone | not null
 region        | character varying(30)    | not null
 dateiname     | character varying(255)   | 
 volltext      | text                     | not null
 titleidx      | txtidx                   | 
Indexes: multicom_pkey primary key btree (id),
         mc_id_idx btree (id),
         mc_kennung_idx btree (kennung),
         mc_lieferdatum_idx btree (datum),
         mc_rubpriogue_idx btree (kategorie, rubrik, prioritaet, gueltig_bis),
         mc_zulieferer_idx btree (zulieferer),
         multicom_oid_id_idx btree (oid),
         multicom_txt_t_idx gist (titleidx)
Triggers: RI_ConstraintTrigger_511407218,
          RI_ConstraintTrigger_511407219,
          RI_ConstraintTrigger_511407221,
          RI_ConstraintTrigger_511407222,
          multicomtxtidxupdate

newsdb=# \d multithumb
                                  Table "public.multithumb"
  Column   |          Type          |                        Modifiers                        
-----------+------------------------+---------------------------------------------------------
 t_id      | integer                | not null default nextval('"multithumb_t_id_seq"'::text)
 id        | integer                | not null
 thumbnail | character varying(255) | not null
 thumbimg  | bytea                  | not null
 header    | character varying(30)  | not null
Indexes: multithumb_pkey primary key btree (t_id),
         mthumb_id_idx btree (id)
Triggers: RI_ConstraintTrigger_511407217
