duplicating table

From: "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: duplicating table
Date: 2002-01-10 14:53:09
Message-ID: 73309C2FDD95D11192E60008C7B1D5BB0452DCBC@snt452.corp.bcbsm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Howdy:

I know this will seem silly, but I'm trying to
make a copy of a table with a few modifications.

I have a table like so:

[snip]

Attribute | Type | Modifier
-----------+-------------------+----------
name | character varying |
riskgrp | character(12) |
address | character varying |
city | character varying |
state | character varying |
zip | character varying |
pcgname | character varying |

[/snip]

and i want to create a new table like so:

[snip]
Attribute | Type | Modifier
-----------+-------------------+----------
name | character varying |
riskgrp | character(12) |
address | character varying |
address2 | character varying |
city | character varying |
state | character varying |
zip | character varying |
pcgname | character varying |
mailcode | character(5) |
[/snip]

I can alter the table to add the two
new columns, but I wanted to know if
I can copy the data from the old table
into the new table and put the column
data in the appropriate places
(leaving column: address2 and mailcode empty)?

I have been trying something like:

[example]

insert into t2_ref_pcg_address
select name,riskgrp,address,,city,state,zi p,pcgname from t_ref_pcg_address;

[/example]

And

[example]

select
name,riskgrp,address,,city,state,zip,pcgname from t_ref_pcg_address into
t2_ref_pcg_address;

[/example]

Neither works.

Any suggestions?

Thanks!

-X

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Eckermann 2002-01-10 15:04:24 Re: Performance tips
Previous Message Andrew Perrin 2002-01-10 14:21:23 Re: Performance tips