Moving text columns, when it actually is large

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Moving text columns, when it actually is large
Date: 2009-07-08 21:19:26
Message-ID: 4A550D5E.3020008@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Joseph S 2009-07-09 01:22:41 ERROR: function expression in FROM may not refer to other relations of same query level
Previous Message nha 2009-07-08 10:36:06 Re: Recording how a table is used