I can add that I would like to do this in my java application. E.i. just create an empty table in database1 which has the same column names and types as a table stored in database2.
I tried this for a start: stmnt = dbConnection.prepareStatement("select dblink_connect('myconn', 'dbname=gemaps')"); resultset = stmnt.executeQuery();
but got ERROR: function dblink_connect(unknown, unknown) does not exist
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 restore it into the other database.