Re: COPY table with LOBs

The user who issued the CTAS will own the table unless you tell it otherwise. To create the table under a different user, use the schema-dot notation where you prepend the table name with the owner and a '.' as follows:

CREATE TABLE test.new_table
SELECT * FROM dev.old_table;

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"