Christopher B. Browne's Home Page
cbbrowne@acm.org

8.18. Table: 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

Google
Contact me at cbbrowne@acm.org