Re: [GENERAL] Parsing COPY ... WITH BINARY

2013-02-01 Thread Leonardo M . Ramé
On 2013-01-31 17:38:26 -0600, Merlin Moncure wrote: > On Thu, Jan 31, 2013 at 8:47 AM, Leonardo M. Ramé wrote: > > I'm using this: > > > > COPY( select field1, field2, field3 from table ) TO 'C://Program > > Files/PostgreSql//8.4//data//output.dat' WITH BINARY > > > > To export some fields to a f

Re: [GENERAL] Parsing COPY ... WITH BINARY

2013-01-31 Thread Merlin Moncure
On Thu, Jan 31, 2013 at 8:47 AM, Leonardo M. Ramé wrote: > I'm using this: > > COPY( select field1, field2, field3 from table ) TO 'C://Program > Files/PostgreSql//8.4//data//output.dat' WITH BINARY > > To export some fields to a file, one of them is a ByteA field. Now, I > need to read the file

[GENERAL] Parsing COPY ... WITH BINARY

2013-01-31 Thread Leonardo M . Ramé
I'm using this: COPY( select field1, field2, field3 from table ) TO 'C://Program Files/PostgreSql//8.4//data//output.dat' WITH BINARY To export some fields to a file, one of them is a ByteA field. Now, I need to read the file with a custom made program. How can I parse this file? BTW: I cannot