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.
