Graphics

On 21/01/2008 18:57, Bob Pawley wrote:

Is there any method of incorporating the graphics into PostgreSQL so
that they become part of the database on pg_dump????

Surely - use type bytea.

Ray.

---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------

Bob Pawley wrote:

I use graphics in the application I am writing with PostgreSQL as the

database.

I am storing the graphics in a file separate from Postgres and

accessing

them using lo_import.

Is there any method of incorporating the graphics into PostgreSQL so

that

they become part of the database on pg_dump????

For older versions of pg_dump (pre-8.1 I think) the -b flag was needed.
Recent versions include large objects by default when you're dumping an
entire database, as opposed to a selection of objects.

Also in the dump file it produces, there should be "SELECT
lo_open(lo_create(..." commands, that's how the large objects are
populated.

If not, what version of pg_dump and what command-line options are you
using?

--
Daniel
PostgreSQL-powered mail user agent and storage:
http://www.manitou-mail.org