unsubscribe
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
banghe wrote:
One sql statement can solve this:
sql> isnert into table_b (id, name, summary) select id, name, desc
from table_a;
Banghe
Mike Darretta wrote:
Does anyone have a suggestion on the best way to migrate data between
two slightly different tables? For example:
Table A
Does anyone have a suggestion on the best way to migrate data between
two slightly different tables? For example:
Table A
id : integer
name : string
desc : string
Table B
id : integer
name : string
date : date
summary : string
In this example, I would like to copy all the data f
Thanks. I'll investigate and let you know how things go
Mike
Tom Lane wrote:
Mike Darretta <[EMAIL PROTECTED]> writes:
I'm an application developer trying to understand a pg data partition
issue. We are storing large objects (gifs) at a rate of about 1GIG /day.
After about
I'm an application developer trying to understand a pg data partition
issue. We are storing large objects (gifs) at a rate of about 1GIG /day.
After about a week, most of the objects are recycled -- that is, an
insert triggers a delete of a similar object. The postgres data
partition, though, c
