At the moment I am using an old PG version on my machine. and it shows all the file names by their real name under : /usr/local/psql/data/base/mydatabasename/
Having pgdump or copy commands, why one might need to know the relation between the numbers and the names at all? Data base recovery or data backup process or... ? >From: Srinivasa R Chava <[EMAIL PROTECTED]> >To: omid omoomi <[EMAIL PROTECTED]> >Subject: Re: [ADMIN] finding file names >Date: Thu, 17 Jan 2002 08:51:43 -0600 > >hi, >My question is not how to copy a text file into a table or >moving data from table to text file. >The postgresql database file will be located in PGDATA directory >and they are in numbered, not named. and their directory is also >numbered like 1820. under 1820, there are several data file. >How to know which data file belong to which object. >Thanks >chava >-- > >Srinivasa R Chava (Chava) <[EMAIL PROTECTED]> > - Boss: Sean T Laduderdale <[EMAIL PROTECTED]> >vnet4603575 >Application Developer >Corporate Intra/Internet Systems >WORLDCOM - http://www.worldcom.com/ - NASDAQ:WCOM >500 Clinton Center Drive (Corporate Headquarters) >Clinton, Mississippi (MS) USA 39056 >(601)460-3122 / vnet4603122 / (800)844-1009 / FAX(601)460-8257 _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
