Re: Query output into a space delimited/location sensitive file - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Query output into a space delimited/location sensitive file
Date
Msg-id dcc563d10802161729x381996e9gdd1b568038ffe850@mail.gmail.com
Whole thread Raw
In response to Re: Query output into a space delimited/location sensitive file  (Ubence Quevedo <r0d3nt@pacbell.net>)
List pgsql-general
On Feb 16, 2008 7:19 PM, Ubence Quevedo <r0d3nt@pacbell.net> wrote:
> Scott, you are exactly right.  I am looking to take various data in
> multiple tables and create an output file delimited into specific
> sections.  I'll look more into the proper usage of select into as well
> as the substring/field example you have given below.

Then you'll be wanting lpad or rpad to make the fixed widths.  It's
pretty straight ahead.

pgsql-general by date:

Previous
From: Ubence Quevedo
Date:
Subject: Re: Query output into a space delimited/location sensitive file
Next
From: Tom Lane
Date:
Subject: Re: Strict-typing benefits/costs