I need to copy one table (properties and data both) from one database to another. I am using pgAdmin III.
I tried doing it with pg_dump and psql, but I guess I don't have the correct syntax.
Table_name : table1
source database name: test_db
dest. database name: prod_db
In both the databases, the schema is public. and these 2 databases are on different machines.
Please help. Thank you.