Re: Creating Text Files from Tables - Mailing list pgsql-novice

From John DeSoi
Subject Re: Creating Text Files from Tables
Date
Msg-id 3FAFD21B-FBD8-4DE5-BB8B-9B05DAE48BC5@pgedit.com
Whole thread Raw
In response to Creating Text Files from Tables  ("Warren Murray" <murray_warren@bah.com>)
List pgsql-novice
On Feb 10, 2006, at 8:06 AM, Warren Murray wrote:

> This maybe be on a more complex side, but I'm a novice to say the
> least, how
> can I  export a text delimited file from Postgresql.  The file will be
> transferred into a specific directory for use with another system.
> text
> file row sample: 396,"bigshoes.blue.7"

The COPY command can produce CSV files (as well as files with other
delimiters):

http://www.postgresql.org/docs/8.1/interactive/sql-copy.html



>
> My last question is how can I create a series of fixed-width text
> files from
> tables and/or queries in a Postgresql database?


You could write some pl/pgsql functions to write the data to a temp
table and then COPY it.




John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL


pgsql-novice by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: Creating Text Files from Tables
Next
From: Michael Fuhr
Date:
Subject: Re: Creating Text Files from Tables