[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
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)-
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
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