I'm looking possible way to copy some tables of one PostgreSQL DB to another DB. With PGAdmin, backup and restore is really confusing and mess. Is there a way to backup and restore specific tables via Heroku CLI? Or some other ways?
Asked
Active
Viewed 33 times
0
-
`pg_dump -t the_table ...` https://www.postgresql.org/docs/current/static/app-pgdump.html – a_horse_with_no_name Apr 10 '18 at 11:17
-
See e.g. [here](https://stackoverflow.com/q/3049864/330315) or [here](https://stackoverflow.com/q/1237725/330315) – a_horse_with_no_name Apr 10 '18 at 11:20