[postgis-users] copying tables from one schema to another

[Mr. Puneet Kishor]

On Sep 22, 2011, at 6:29 AM, Robert Buckley wrote:

> Hi,
> 
> As a follow-up to my earlier post (Re: [postgis-users] schemas and postgis data) I have another question.
> 
> I had originally put all my data into the public schema. I want to move my geodata to the schema "data", so I just used to following command in the pgadmin3 sql editor
> 
> create table data.new_table as (select * from public.old_table);


Don't recreate the tables. Just alter the schema. Check the Pg docs for changing the schema.


> 
> although this works, the schema is not copied..ie the primary key and other contraints are missing.
> 
> So i have done this
> 
> # first create new table and copy schema
> create table data.table_2(like table_1 including defaults including constraints including indexes);
> 
> #then copy data into table_2
> insert into data.table2(select * from public.table_1);
> 
> Is there a better/quicker/safer way of doing this? possibly with pgadmin3?_______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users