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.
Thanx!
On Feb 16, 2008, at 04:12 PM, Scott Marlowe wrote:
On Feb 16, 2008 5:29 PM, Bruce Momjian <bruce@xxxxxxxxxx> wrote:
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.
I think the OP was just looking at processing fixed with records into
pgsql. If that's the case you can make a load table with one text
field and select into from it with something like substring(field,1,5)
etc...
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
