Re: pg_lo_import alternative ...

Are there many images?

I do not suggest to store the images in the database. Better save them on
the disk and in the database save only the path to the image. Think also to
the size of the dump(with images).

It is more easy to handle this way.

This is my opinion.

Best regards.
Andy.

----- Original Message -----
From: "Daniel Rubio" <drubior(at)tinet(dot)org>
To: <pgsql-admin(at)postgresql(dot)org>
Sent: Wednesday, November 26, 2003 3:58 PM
Subject: [ADMIN] pg_lo_import alternative ...

> Hi all.
>
> One of our clients wants to store images into his postgres database
> hosted by us.
>
> To do this is trying to use the PHP function pg_lo_import, receiving
> this error message from server:
>
> Waning: pg_query() [function.pg-query]: Query failed: ERROR: You must
> have Postgres superuser privilege to use server-side lo_import(). Anyone
> can use the client-side lo_import() provided by libpq. . in
> /apps/web/html/funcions.php on line 121
>
> I can read that there's a client-side function in libpq, but I can't
> find any information about it and their use.
>
> Anyone knows something?
> --
> ********************************************************
> Daniel Rubio Rodríguez
> OASI (Organisme Autònom Per la Societat de la Informació)
> c/ Assalt, 12
> 43003 - Tarragona
> Tef.: 977.244.007 - Fax: 977.224.517
> e-mail: drubio(at)oasi(dot)org
> ********************************************************
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend