| From: | Sameer Kumar <sameer(dot)kumar(at)ashnik(dot)com> |
|---|---|
| To: | Alex Ignatov <a(dot)ignatov(at)postgrespro(dot)ru>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pg_dump without any SET command in header of output plain text sql file |
| Date: | 2016-07-20 18:02:17 |
| Message-ID: | CADp-Sm7-jVs65L9mRNqX_SkUbSt_1=V0-sC8T+7kQTZdMhXUzQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 21 Jul 2016, 1:17 a.m. Alex Ignatov, <a(dot)ignatov(at)postgrespro(dot)ru>
wrote:
> Hello everyone!
>
> Is there any way to make pg_dump(9.5) to dump table (with data) without
> any SET command in the header of output plain sql file?
>
Yeah you need to use specific switch/option to disable each set command
> P.S. Yeah I know about sedding =)
>
>
> --
> Alex Ignatov
> Postgres Professional: http://www.postgrespro.com
> The Russian Postgres Company
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Lybarger | 2016-07-20 18:14:00 | unique constraint with several null values |
| Previous Message | Steve Langlois | 2016-07-20 17:44:33 | Re: Is it possible to control the location of the lock file when starting postgres? |