public inbox for [email protected]
help / color / mirror / Atom feedFrom: Joe Conway <[email protected]>
To: Brice Maron <[email protected]>
Cc: [email protected]
Subject: Re: Sqlectron
Date: Mon, 22 Jan 2018 17:04:43 -0500
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAHBQ7mfcHJfHeEj29+ZrW6UvWAsDO6-T8y9yHZa-dxamVUkUqg@mail.gmail.com>
References: <CAHBQ7mdnCPsGQ5V7vHNG9MAxXnt9eNY+RJqnLsrBo2-CwwFpUw@mail.gmail.com>
<[email protected]>
<CAHBQ7mfcHJfHeEj29+ZrW6UvWAsDO6-T8y9yHZa-dxamVUkUqg@mail.gmail.com>
On 01/22/2018 04:38 PM, Brice Maron wrote:
> but what i was really looking for is something more in the shape of :
>> Create table foo (id integer, ...., );
> as pg_dump can give you
Ah, for that you probably need to look through pg_dump source code, or
perhaps pgadmin source code for a head start. There are also functions here:
https://www.postgresql.org/docs/10/static/functions-info.html
But really the simplest answer in my experience is to use pg_dump with
--schema-only and --table=table options.
Joe
--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development
Attachments:
[application/pgp-signature] signature.asc (819B, ../[email protected]/2-signature.asc)
download
view thread (4+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Sqlectron
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox