Re: Query output into a space delimited/location sensitive file

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Ubence Quevedo" <r0d3nt(at)pacbell(dot)net>
Cc: "Bruce Momjian" <bruce(at)momjian(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: Query output into a space delimited/location sensitive file
Date: 2008-02-17 01:29:13
Message-ID: dcc563d10802161729x381996e9gdd1b568038ffe850@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Feb 16, 2008 7:19 PM, Ubence Quevedo <r0d3nt(at)pacbell(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-02-17 02:40:37 Re: Strict-typing benefits/costs
Previous Message Ubence Quevedo 2008-02-17 01:19:28 Re: Query output into a space delimited/location sensitive file