Thread: finding file names
In Postgresql the data file are created and named in numeric format, instead of text format. I would like move some of big tables' files to another disk. But how to find out which file belong to which table. How to map the numeric files to its respective database objects? Thanks in advance for any help.
On 16 Jan 2002, Srinivasa Rao Chava wrote: > In Postgresql the data file are created and named in numeric format, > instead of text format. > I would like move some of big tables' files to another disk. But how > to find out which file belong to which table. > How to map the numeric files to its respective database objects? > Thanks in advance for any help. See contrib/oid2name
hi, You can use COPY command to make a text file for any table. regards Omid Omoomi >From: s.chava@wcom.com (Srinivasa Rao Chava) >To: pgsql-admin@postgresql.org >Subject: [ADMIN] finding file names >Date: 16 Jan 2002 15:15:24 -0800 > >In Postgresql the data file are created and named in numeric format, >instead of text format. >I would like move some of big tables' files to another disk. But how >to find out which file belong to which table. >How to map the numeric files to its respective database objects? >Thanks in advance for any help. > >---------------------------(end of broadcast)--------------------------- >TIP 3: if posting/reading through Usenet, please send an appropriate >subscribe-nomail command to majordomo@postgresql.org so that your >message can get through to the mailing list cleanly _________________________________________________________________ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx
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