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 <s.chava@wcom.com>
>To: omid omoomi <oomoomi@hotmail.com>
>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) <s.chava@wcom.com>
> - Boss: Sean T Laduderdale <sean.lauderdale@wcom.com>
>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