MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8;
 format=flowed
Content-Transfer-Encoding: 8bit
Date: Sun, 17 Mar 2019 09:49:50 +0100
From: Damien Clochard <damien@dalibo.info>
To: pgsql-gui-dev@lists.postgresql.org
Subject: Export the CREATE TABLE command in pure SQL
Message-ID: <2bc470194b4837c1f733a4e05f569bc6@dalibo.info>
User-Agent: Roundcube Webmail/1.3.8
Precedence: bulk

hey guys,

The most effective and simplest way to export the creation command of a 
table is to use `pg_dump --schema-only`

However for one my projects, I don't have access to pg_dump and I need 
to extract the data with a SQL or pl/pgsql function. I already wrote a 
naïve implementation that handles primary keys and temporary tables. But 
I realize it's probably incomplete and I will have to maintain it for 
every new PostgreSQL major version....

How do you guys deal with this ? It seems that a lot of GUI tools are 
able to "export the table structure".... Is there an extension somewhere 
to do that ? Is it possible to write i in pure SQL ? If yes, there 
anybody here interested in joining forces to build a shared export 
function ?

Have nice day !

-- 
Damien Clochard