Hello I have a database in postgres 9 which I have 139 tables but I need to copy only 7 tables that are new to put them in another database, If you can tell me how I thank you Thank you.
Hello I have a database in postgres 9 which I have 139 tables but I need to copy only 7 tables that are new to put them in another database, If you can tell me how I thank you Thank you.
From the command line:
EXPORT TABLE
pg_dump -i -h [servidor] -p 5432 -U [usuario] -t [tabla] -F p -b -v -f "mitabla.sql" [basedatos]
IMPORT TABLE
psql -h [servidor] -d [basedatos] -U [usuario] -f "mitabla.sql"