Postgres Pro
Downloads
Home   >   mailing lists

Re: Writing to a flat file using procedures - Mailing list pgsql-admin

From Jim C. Nasby
Subject Re: Writing to a flat file using procedures
Date
Msg-id 20060212001041.GV57845@pervasive.com
Whole thread Raw
In response to Writing to a flat file using procedures  ("Nalin Bakshi" <nbakshi@bisil.com>)
List pgsql-admin
Tree view 
On Sat, Feb 11, 2006 at 10:48:08AM +0530, Nalin Bakshi wrote:
> Hi!
>     My project requires me to fetch some data from a a table and write it into a flat file. How can I do this. Could
youhelp? 
> regards,

http://www.postgresql.org/docs/8.1/interactive/sql-copy.html
See also \copy on
http://www.postgresql.org/docs/8.1/interactive/app-psql.html , which
removes the need for the file to be writable by the back-end.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

pgsql-admin by date:

Previous
From: lst_hoe01@kwsoft.de
Date:
Subject: Re: Postgresql performance and tuning questions
Next
From: Tom Lane
Date:
Subject: Re: Postgresql performance and tuning questions