Re: [GENERAL] Copying bytea data out via pgsql

2005-07-23 Thread Edmund
[EMAIL PROTECTED] (Leonel Nunez) writes: > John Wells wrote: > > >Guys, > > > >I have a number of jpegs and tiffs that are stored in a bytea field in a > >PostgreSQL database by a Java program using Hibernate. > > > >I need to copy these out to a flat file via pgsql for viewing, etc. I've > >tri

Re: [GENERAL] Copying bytea data out via pgsql

2005-07-23 Thread John Wells
Leonel Nunez said: > > I hope this helps Leonel, Worked perfectly...thanks. I'll do the same thing via Java for my future use (can't guarantee Perl will be available on all of our target machines). I appreciate the help! John ---(end of broadcast)-

Re: [GENERAL] Copying bytea data out via pgsql

2005-07-22 Thread Leonel Nunez
John Wells wrote: Guys, I have a number of jpegs and tiffs that are stored in a bytea field in a PostgreSQL database by a Java program using Hibernate. I need to copy these out to a flat file via pgsql for viewing, etc. I've tried psql -c 'select binarydata_field from my_image_table where id

[GENERAL] Copying bytea data out via pgsql

2005-07-22 Thread John Wells
Guys, I have a number of jpegs and tiffs that are stored in a bytea field in a PostgreSQL database by a Java program using Hibernate. I need to copy these out to a flat file via pgsql for viewing, etc. I've tried psql -c 'select binarydata_field from my_image_table where id=1' mydb > flatfile