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

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Ubence Quevedo <r0d3nt(at)pacbell(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Query output into a space delimited/location sensitive file
Date: 2008-02-16 23:29:36
Message-ID: 200802162329.m1GNTaj20892@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ubence Quevedo wrote:
> What would the command be to have a query result be put into a
> location/space sensitive file [position 1 through 5 would be one thing
> where position 6 through 10 would be the next field, 11 through 16
> another, etc]? Is this even possible with Postgres?

Not possible --- many data types are of variable length.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-02-17 00:12:38 Re: Query output into a space delimited/location sensitive file
Previous Message Bruce Momjian 2008-02-16 23:19:35 Re: Pains in upgrading to 8.3