| Slony-I 1.2.23 Documentation | ||||
|---|---|---|---|---|
| Prev | Fast Backward | Chapter 1. Schema schemadoc | Fast Forward | Next |
1.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
Tables referencing sl_trigger via Foreign Key Constraints