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