Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1edkD2-0005Cd-46 for pgsql-gui-dev@arkaria.postgresql.org; Mon, 22 Jan 2018 22:04:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1edkD1-000690-Nz for pgsql-gui-dev@arkaria.postgresql.org; Mon, 22 Jan 2018 22:04:55 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1edkD1-00068r-Jh for pgsql-gui-dev@lists.postgresql.org; Mon, 22 Jan 2018 22:04:55 +0000 Received: from 104-190-1-44.lightspeed.sndgca.sbcglobal.net ([104.190.1.44] helo=joeconway.com) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1edkCy-00068e-DT for pgsql-gui-dev@lists.postgresql.org; Mon, 22 Jan 2018 22:04:54 +0000 Received: from [108.225.169.28] (account jconway@joeconway.com HELO [192.168.1.119]) by joeconway.com (CommuniGate Pro SMTP 6.1.4) with ESMTPSA id 19486504; Mon, 22 Jan 2018 14:04:45 -0800 Subject: Re: Sqlectron To: Brice Maron Cc: pgsql-gui-dev@lists.postgresql.org References: From: Joe Conway Openpgp: id=4EA5B4659ED59CC9538139A5332B7E68B699434A Message-ID: <0ec78f52-e346-1217-a650-d75028ad600a@joeconway.com> Date: Mon, 22 Jan 2018 17:04:43 -0500 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.5.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="rPCwAhWaAzZtmCKfN8iRfylYrTDN0lXup" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --rPCwAhWaAzZtmCKfN8iRfylYrTDN0lXup Content-Type: multipart/mixed; boundary="kW58FqtAkNWi1KNEuvxXhAxPlzz7wVFgU"; protected-headers="v1" From: Joe Conway To: Brice Maron Cc: pgsql-gui-dev@lists.postgresql.org Message-ID: <0ec78f52-e346-1217-a650-d75028ad600a@joeconway.com> Subject: Re: Sqlectron References: In-Reply-To: --kW58FqtAkNWi1KNEuvxXhAxPlzz7wVFgU Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: quoted-printable 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 he= re: 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=3Dtable options. Joe --=20 Crunchy Data - http://crunchydata.com PostgreSQL Support for Secure Enterprises Consulting, Training, & Open Source Development --kW58FqtAkNWi1KNEuvxXhAxPlzz7wVFgU-- --rPCwAhWaAzZtmCKfN8iRfylYrTDN0lXup Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iQIcBAEBCAAGBQJaZl/7AAoJEDfy90M199hlkX4P/3Aw7K+OUiUTwvN/hq6slt5Y BH65d+KtkCOPKMB6mzDEJ/xvLzbJ1MOVE4eR93heaE7nvBA8JAxbasYW6jt9H47s OdZlf9ZhBqlht0GwXBqiQQT/2coBg2bRRam7szobU9vmYM/tdI0ou5g2v0mHKj/C vOg2UFhvZ58k/KnXAwQ5B8wtae8ujYKFUF3D/8gj57F7HmsMj4RkXMtNbe4rMOfq SHNy3kPbWFXFGYkYekXW7ADJnEANEkHiqpYok3/kOWIfRnvVrLkJ/9bMGXtcN4YY lg3r+WamwRassJV2Oi6tApyRfSYRYrX1J/meeYWJ//Fl0xfv10C195N0+ZxyoIzz KMgByTmnWJWerHeGC4ojAxSs68yATmQ18roYh9Jqy0XDNPFEiGhI/WW5ZgpB1GnX S7uCYZ52X0eWPHnbU4AazJLZJj8DY7JskoRme7JQVLKqsqFAeaq1xMqygJn/V4Rx /YvZxKDRQUH8/Ka06Kgpz2oKfIEXedbIGMjr9B3kuTsSpy7YvIyq4zX12VfUtd1E SIirxAsGPqkk+r4/zlDAMzCg8Jzh9JElT/1+E25DrIBjHAMv5E7z2EjDZojqaRbn LhalGJGpxTccuXFxbA+bCklyeovKDhNZkFv/Sb6/MzJZUKt9/tLlYSHkLrw5c7PE a8uavi89qeyGyPDIpjEm =PVJn -----END PGP SIGNATURE----- --rPCwAhWaAzZtmCKfN8iRfylYrTDN0lXup--