|
Dear Richard,
Regarding the information you give to me, I understand that this information is a thing that normally used by PostgreSQL system. And the information seem to be placed on a comment area. So, Who need to have a clearly understanding on the header information?
Thank you
>>> Richard Huxton <dev@xxxxxxxxxxxx> 11/6/2006 15:41 >>> 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 NETsolutions Asia Limited +66 (2) 237 7247
|
