[GENERAL] Copying Blobs between two tables using Insert stmt

2008-10-17 Thread John Skillings
Hi all, I am trying to copy blobs between two tables and need help on the best way to get this done. My requirement is that the both the tables maintain their own copy of the large object, instead of sharing the OID. I created two tables: create table table_a (id bigserial not null, filename o

Re: [GENERAL] Copying Blobs between two tables using Insert stmt

2008-10-17 Thread John Skillings
12:32 PM, Diogo Biazus <[EMAIL PROTECTED]> wrote: > > Em 17/10/2008, às 18:18, John Skillings escreveu: > > > Hi all, >> >> I am trying to copy blobs between two tables and need help on the best way >> to get this done. My requirement is that the both the t

Re: [GENERAL] Copying Blobs between two tables using Insert stmt - [SOLUTION]

2008-10-17 Thread John Skillings
, filename) values ( nextval('table_b_id_seq'), v_NewOID ); Works well so far. John On Fri, Oct 17, 2008 at 1:37 PM, John Skillings <[EMAIL PROTECTED]>wrote: > Hi Diogo, > > Thanks for your response. However, my requirement is to have two separate > copies