hi, You can use COPY command to make a text file for any table. regards Omid Omoomi
>From: [EMAIL PROTECTED] (Srinivasa Rao Chava) >To: [EMAIL PROTECTED] >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 [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]