Re: Want to disable fully qualified table names on pg_dump in pg_dump (PostgreSQL) 9.6.8

2018-03-16 Thread Adrian Klaver
On 03/16/2018 01:55 PM, Foolish Ewe wrote: Thank you Adrian, this is informative. With best regards: On a hunch: 1) Installed SQL Workbench/J (https://www.sql-workbench.eu/index.html) 2) Set up Postgres JDBC driver(https://jdbc.postgresql.org/download.html) 3) Opened DbExplorer: https://ww

Re: Want to disable fully qualified table names on pg_dump in pg_dump (PostgreSQL) 9.6.8

2018-03-16 Thread Foolish Ewe
Thank you Adrian, this is informative. With best regards: Bill From: Adrian Klaver Sent: Thursday, March 15, 2018 11:09 PM To: Foolish Ewe; pgsql-general@lists.postgresql.org Subject: Re: Want to disable fully qualified table names on pg_dump in pg_dump

Re: Want to disable fully qualified table names on pg_dump in pg_dump (PostgreSQL) 9.6.8

2018-03-15 Thread Adrian Klaver
On 03/15/2018 04:00 PM, Foolish Ewe wrote: Hello All: A number of our team members and I use pg_dump to export schema in an Ubuntu 16.04 environment, I happen to have a postgress 9.6.4 server that runs in a docker container, and in some cases I see the following select statement and fully qual

Want to disable fully qualified table names on pg_dump in pg_dump (PostgreSQL) 9.6.8

2018-03-15 Thread Foolish Ewe
Hello All: A number of our team members and I use pg_dump to export schema in an Ubuntu 16.04 environment, I happen to have a postgress 9.6.4 server that runs in a docker container, and in some cases I see the following select statement and fully qualified table names in the CREATE TABLE and ALT