Re: duplicating table

-----Original Message-----
From: Johnson, Shaunn [mailto:SJohnson6@bcbsm.com]
Sent: Thursday, January 10, 2002 9:53 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] duplicating table

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