sl_table
Holds information about the tables being replicated.
Structure of sl_table
tab_id
integer PRIMARY KEY
Unique key for Slony-I to use to identify the table
tab_reloid
oid UNIQUE NOT NULL
The OID of the table in pg_catalog.pg_class.oid
tab_relname
name NOT NULL
The name of the table in pg_catalog.pg_class.relname used to recover from a dump/restore cycle
tab_nspname
name NOT NULL
The name of the schema in pg_catalog.pg_namespace.nspname used to recover from a dump/restore cycle
tab_set
integer REFERENCES sl_set
ID of the replication set the table is in
tab_idxname
name NOT NULL
The name of the primary index of the table
tab_altered
boolean NOT NULL
Has the table been modified for replication?
tab_comment
text
Human-oriented description of the table
Prev | Home | Next |
Table:
sl_subscribe | Up | add_empty_table_to_replication(integer, integer, text, text, text, text) |