Postgres Pro
Downloads
Home   >   mailing lists

Re: Want to disable fully qualified table names on pg_dump in pg_dump(PostgreSQL) 9.6.8 - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Want to disable fully qualified table names on pg_dump in pg_dump(PostgreSQL) 9.6.8
Date
Msg-id d608b355-8e49-9814-9984-b6684cbe6fe1@aklaver.com
Whole thread Raw
In response to Re: Want to disable fully qualified table names on pg_dump in pg_dump(PostgreSQL) 9.6.8  (Foolish Ewe <foolishewe@hotmail.com>)
List pgsql-general
Tree view 
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.klaver@aklaver.com

pgsql-general by date:

Previous
From: "Victoria Stuart (VictoriasJourney.com)"
Date:
Subject: Re: Nvim as external editor in psql as Postgres root user - .vimrc(environment?) issue
Next
From: hmidi slim
Date:
Subject: Could not open extension control file “/usr/share/postgresql/10/extension/pg_similarity.control”: No such file or directory