Properties

Name: pg_amop1 
Owner: postgres 
Tablespace:  
Has indexes:  
Has rules:  
Has triggers:  
Inherited Tables Count:
Comment:  

Columns

Name Type Length Default value Comment
  tableoid  oid  -1     
  cmax  cid  -1     
  xmax  xid  -1     
  cmin  cid  -1     
  xmin  xid  -1     
  ctid  tid  -1     
  amopclaid  oid  -1     
  amopsubtype  oid  -1     
  amopstrategy  int2  -1     
  amopreqcheck  bool  -1     
  amopopr  oid  -1     
Total: 11 column(s)

Constraints

Name Type Deffered
  ddd  unique   
Total: 1 constraint(s)

Indexes

Name Unique Primary key Clustered
  index1       
Total: 1 index(es)

Rules

Name Type Instead
  ddd  DELETE   
Total: 1 rule(s)

Triggers

Name Trigger function Enabled Deferrable Initially deferred
  tr_amo1  flatfile_update_trigger       
Total: 1 trigger(s)

SQL


CREATE TABLE pg_amop1 (
    amopclaid oid NOT NULL,
    amopsubtype oid NOT NULL,
    amopstrategy smallint NOT NULL,
    amopreqcheck boolean NOT NULL,
    amopopr oid NOT NULL
);


ALTER TABLE public.pg_amop1 OWNER TO postgres;

See Also

List of tables