Moving text columns, when it actually is large - Mailing list pgsql-sql

From Rob Sargent
Subject Moving text columns, when it actually is large
Date
Msg-id 4A550D5E.3020008@gmail.com
Whole thread Raw
Responses Re: Moving text columns, when it actually is large
List pgsql-sql
I have to restructure some tables, coalescing common elements from three 
tables (sub-classes) into a single table (super-class).  Each source 
table has a text field which actually gets stuffed with a largish (1Mb+) 
blob of xml.

Is there any way to simply, um, er, transplant the pointer rather than 
actually copy the data?

Ever hopeful,
rjs


pgsql-sql by date:

Previous
From: nha
Date:
Subject: Re: Recording how a table is used
Next
From: Joseph S
Date:
Subject: ERROR: function expression in FROM may not refer to other relations of same query level