Re: [GENERAL] creating a table based on a table in stored in another database

2010-05-18 Thread Scott Mead
B) Run the dblink SQL file? --Scott /P > -Original Message- > From: pgsql-general-ow...@postgresql.org [mailto: > pgsql-general-ow...@postgresql.org] On Behalf Of A. Kretschmer > Sent: den 18 maj 2010 10:16 > To: pgsql-general@postgresql.org > Subject: Re: [GENERAL] creat

Re: [GENERAL] creating a table based on a table in stored in another database

2010-05-18 Thread Malm Paul
en 18 maj 2010 10:16 To: pgsql-general@postgresql.org Subject: Re: [GENERAL] creating a table based on a table in stored in another database In response to Malm Paul : > Hi list, > in a database I have different kind of tables. I would like to take the meta > data from one of those tables

Re: [GENERAL] creating a table based on a table in stored in another database

2010-05-18 Thread A. Kretschmer
In response to Malm Paul : > Hi list, > in a database I have different kind of tables. I would like to take the meta > data from one of those tables and create the same type of table (but empty) > in another database. > Can anyone, please, tell me how to do this? Create a schema-only dump and r

[GENERAL] creating a table based on a table in stored in another database

2010-05-18 Thread Malm Paul
Hi list, in a database I have different kind of tables. I would like to take the meta data from one of those tables and create the same type of table (but empty) in another database. Can anyone, please, tell me how to do this? Kind regards, Paul -- Sent via pgsql-general mailing list (pgsql-