Restoring a table with blobs - Without doing a full restore - Is it even possible ?

From: o(dot)blomqvist(at)secomintl(dot)com (Otto Blomqvist)
To: pgsql-general(at)postgresql(dot)org
Subject: Restoring a table with blobs - Without doing a full restore - Is it even possible ?
Date: 2004-06-18 15:18:40
Message-ID: c501cb7d.0406180718.460ae1f8@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello !

I have a table that is created as follows

Create Table file_200 (Record_number integer, Customer_Image OID;
CREATE UNIQUE INDEX file_200_Record_Number_Key ON file_200
(record_number);

I store pictures using (In Delphi 7)

PSQLImageQuery.Edit;
PSQLImageQuerycustomer_image.LoadFromFile('c:\tmp.jpg');
PSQLImageQuery.Post;

Everything works just wonderfully, even a full dump and restore works
like a charm (Using pg_dump, pg_restore).

Now, of course thats not good enough..hehe. I need to be able to make
a partial restore of the picture table only (there are about 30
diffrent tables, it is not a huge database, 30MB compressed tar.gz). I
tried using the pg_restore -t flag and it runs threw with no errors.
The problem is that the pictures are simply not there and I can not
even overwrite them with new ones. Also, the index is not restored.
When I load the pictures I simply do a "where record_number=##" query
and then the DBImage component does the rest.

I am using PSQL 7.2

Any ideas ?

Thanks a lot

/otto blomqvist

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2004-06-18 15:22:26 Re: virtual fields on VIEW?
Previous Message Najib Abi Fadel 2004-06-18 15:08:43 Re: virtual fields on VIEW?