| From: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
|---|---|
| To: | Nalin Bakshi <nbakshi(at)bisil(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Writing to a flat file using procedures |
| Date: | 2006-02-12 00:10:41 |
| Message-ID: | 20060212001041.GV57845@pervasive.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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 you help?
> 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(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-02-12 00:45:57 | Re: Postgresql performance and tuning questions |
| Previous Message | lst_hoe01 | 2006-02-11 18:49:50 | Re: Postgresql performance and tuning questions |