| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Foolish Ewe <foolishewe(at)hotmail(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Want to disable fully qualified table names on pg_dump in pg_dump (PostgreSQL) 9.6.8 |
| Date: | 2018-03-16 21:41:39 |
| Message-ID: | d608b355-8e49-9814-9984-b6684cbe6fe1@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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://www.sql-workbench.eu/manual/dbexplorer.html
4) Selected all the objects in a schema and used Create DDL Script to
generate a file with the objects. The objects where not created with a
schema qualifier.
>
> Bill
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | hmidi slim | 2018-03-16 22:18:16 | Could not open extension control file “/usr/share/postgresql/10/extension/pg_similarity.control”: No such file or directory |
| Previous Message | Victoria Stuart (VictoriasJourney.com) | 2018-03-16 21:17:07 | Re: Nvim as external editor in psql as Postgres root user - .vimrc (environment?) issue |