Re: images and postgreSQL

Hi,

From psql

database=# COPY table TO '/path/file.txt' USING DELIMITERS '|';

And then view or import to an other application (excel, access ...)?

BR,

Aarni

On Tuesday 14 September 2004 00:29, you wrote:
> Hi,
>
> I have a customer who would like to extract all their data from one system
> and dump into another.  Not too difficult except for the images.  The
> images are housed on another server and separately maintained through a
> postgresql database.   I believe there should be a unique image id that
> links the images on the postgresql database to the primary application
> database.  Unfortunately my knowledge of this postgresql is minimal at best
> and I need to know how to go about extracting the relevant data.  From the
> look of things on the image server, each image is stored on the filesystem
> rather than in the database itself.  So I'm probably just looking for a
> table that stores the image ID and its directory path.  Once I find that
> table, is there a quick way to extract the information?
>
> Any additional information on how you would approach this would be very
> helpful.
>
> Thanks
>
> S.

--
-------------------------------------------------
Aarni Ruuhimäki | Megative Tmi | KYMI.com |
Pääsintie 26 | 45100 Kouvola | FINLAND |

This is a bugfree broadcast to you from a linux system.