Re: finding file names

From: "omid omoomi" <oomoomi(at)hotmail(dot)com>
To: s(dot)chava(at)wcom(dot)com, pgsql-admin(at)postgresql(dot)org
Subject: Re: finding file names
Date: 2002-01-17 14:08:41
Message-ID: F1021YLLl7lZSLSDmR60001f9ca@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

hi,
You can use COPY command to make a text file for any table.

regards
Omid Omoomi

>From: s(dot)chava(at)wcom(dot)com (Srinivasa Rao Chava)
>To: pgsql-admin(at)postgresql(dot)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(at)postgresql(dot)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

Browse pgsql-admin by date

  From Date Subject
Next Message Jan Wieck 2002-01-17 15:04:26 Re: [HACKERS] CREATE OR REPLACE VIEW / TRIGGER
Previous Message Rasmus Mohr 2002-01-17 10:35:14 Re: client connection problem