MIME-Version: 1.0
References: <2bc470194b4837c1f733a4e05f569bc6@dalibo.info>
In-Reply-To: <2bc470194b4837c1f733a4e05f569bc6@dalibo.info>
From: Maxim Sobolevskiy <maxim.sobolevskiy@jetbrains.com>
Date: Tue, 19 Mar 2019 11:51:04 +0300
Message-ID: 
 <CAB65UsX=vjCYXBc7Q2t3aG6u2sH8iWZs7oZVJz1gwfrkny+42A@mail.gmail.com>
Subject: Re: Export the CREATE TABLE command in pure SQL
To: Damien Clochard <damien@dalibo.info>
Cc: pgsql-gui-dev@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000950ff605846e9b95"
Precedence: bulk

--000000000000950ff605846e9b95
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

In DataGrip, which is java-application, we first get all attributes of the
object from the database, then Java-code generates the whole DDL based on
the attributes we have.

On Sun, Mar 17, 2019 at 11:49 AM Damien Clochard <damien@dalibo.info> wrote=
:

> 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=C3=AFve 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
>
>

--=20
Max Sobolevskiy
Product Marketing Manager of DataGrip
JetBrains

--000000000000950ff605846e9b95
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">In DataGrip, which is java-application, we first get all a=
ttributes of the object from the database, then Java-code generates the who=
le DDL based on the attributes we have.</div><br><div class=3D"gmail_quote"=
><div dir=3D"ltr" class=3D"gmail_attr">On Sun, Mar 17, 2019 at 11:49 AM Dam=
ien Clochard &lt;<a href=3D"mailto:damien@dalibo.info">damien@dalibo.info</=
a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0p=
x 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">he=
y guys,<br>
<br>
The most effective and simplest way to export the creation command of a <br=
>
table is to use `pg_dump --schema-only`<br>
<br>
However for one my projects, I don&#39;t have access to pg_dump and I need =
<br>
to extract the data with a SQL or pl/pgsql function. I already wrote a <br>
na=C3=AFve implementation that handles primary keys and temporary tables. B=
ut <br>
I realize it&#39;s probably incomplete and I will have to maintain it for <=
br>
every new PostgreSQL major version....<br>
<br>
How do you guys deal with this ? It seems that a lot of GUI tools are <br>
able to &quot;export the table structure&quot;.... Is there an extension so=
mewhere <br>
to do that ? Is it possible to write i in pure SQL ? If yes, there <br>
anybody here interested in joining forces to build a shared export <br>
function ?<br>
<br>
Have nice day !<br>
<br>
-- <br>
Damien Clochard<br>
<br>
</blockquote></div><br clear=3D"all"><div><br></div>-- <br><div dir=3D"ltr"=
 class=3D"gmail_signature"><div dir=3D"ltr"><div style=3D"font-size:small">=
<div style=3D"font-size:12.8px">Max Sobolevskiy</div></div><div style=3D"fo=
nt-size:12.8px">Product Marketing Manager of DataGrip</div><div style=3D"fo=
nt-size:12.8px">JetBrains</div></div></div>

--000000000000950ff605846e9b95--