PG 9 adminstrations

[Hany ABOU-GHOURY <hghoury@xxxxxxxxx>]

Hi all,

I am trying to update / refresh one table (history) only from prod. database to my test environment database

my query as follows:

pg_dump -h <hostname1> -U postgres -t history DATABASENAME | psql -h hostname2 -U postgres -t history DATABASENAME > db.sql

but I am getting the following error

psql: FATAL:  database "history" does not exist

Can you help please?

what would be the script if I want more than one table (3 tables to refresh)

Kind regards