Premsun Choltanwanich wrote:
Dear All,
I had open the backup file of PostgreSQL created by pg_dump command. I found
that pg_dump make a comment line as header for each module it backup. I try to
understand the meaning of value contained on header for my sample header
--
-- TOC entry 1427 (class 1259 OID 1216127)
-- Dependencies: 7
-- Name: t_option; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
Could you please advise me for.... What does they mean? and What the value used
for?
I'm not sure that they're used for anything in that form - that's just
documenting internal details.
TOC - Table Of Contents
OID - Object IDentifier - as used by PG to reference tables,functions etc.
Dependencies - iirc is the number of references to this table (e.g.
foreign keys).
The others explain themselves.
Check the manual section on system tables, and perhaps try:
SELECT OID,* FROM pg_class WHERE relname='t_option'
HTH
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
