Thread: Graphics

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????

Bob

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