Actually, pg_class.relfilenode.
--------------------------------------------------------------------------- [EMAIL PROTECTED] wrote: > > Thank you Bruce. > > Really, what I would want to know is how PostgreSQL assigns a physical name > to files what represent the database objects. > > I noticed that if I lose a file of the database, the pg_restore program does > not recover it, giving an error because the associated table exists on the > database. On the other hand I can't drop the table because an error occurs: > the file or directory does not exist. > > How I can to solve this problem ? > > Regards, > Fabio Bon > > -----Mensaje original----- > De: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]En nombre de Bruce Momjian > Enviado el: martes 8 de octubre de 2002 23:22 > Para: [EMAIL PROTECTED] > CC: [EMAIL PROTECTED] > Asunto: Re: [ADMIN] Two questions. > > > [EMAIL PROTECTED] wrote: > > Hello ! > > > > Where I can find information, to know since one is organized the system of > > files of a PostgreSQL database ? ( files of database objects ). > > > > If I have a " disc crash " or lose accidental one or several files, since > I > > can realize which lack? > > I wrote something up for 7.3: > > http://developer.postgresql.org/docs/postgres/diskusage.html > > -- > Bruce Momjian | http://candle.pha.pa.us > [EMAIL PROTECTED] | (610) 359-1001 > + If your life is a hard drive, | 13 Roberts Road > + Christ can be your backup. | Newtown Square, Pennsylvania 19073 > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
