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

2008-02-16 Thread Greg Smith
On Fri, 15 Feb 2008, 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 Postgre

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

2008-02-16 Thread Scott Marlowe
On Feb 16, 2008 7:19 PM, Ubence Quevedo <[EMAIL PROTECTED]> 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/fi

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

2008-02-16 Thread Ubence Quevedo
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

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

2008-02-16 Thread Scott Marlowe
On Feb 16, 2008 5:29 PM, Bruce Momjian <[EMAIL PROTECTED]> 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

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

2008-02-16 Thread Bruce Momjian
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 poss