Re: Dump table using pg_dump vs pg_restore -f

2018-11-30 Thread Adrian Klaver
On 11/29/18 7:31 AM, Adrian Klaver wrote: Postgres 10.6 I am getting different output using: pg_dump -d production -U postgresĀ  -s -t container -f cont.sql vs pg_restore -s -t container -f container.sql production_112818.out In the docs: https://www.postgresql.org/docs/10/app-pgrestore.

Dump table using pg_dump vs pg_restore -f

2018-11-29 Thread Adrian Klaver
Postgres 10.6 I am getting different output using: pg_dump -d production -U postgres -s -t container -f cont.sql vs pg_restore -s -t container -f container.sql production_112818.out For the pg_dump version I get: CREATE TABLE public.container ( c_id character varying(10) NOT NULL,