From: | Alex Ignatov <a(dot)ignatov(at)postgrespro(dot)ru> |
---|---|
To: | Sameer Kumar <sameer(dot)kumar(at)ashnik(dot)com>, "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-21 11:14:38 |
Message-ID: | fcebc051-9a73-b1b7-26bc-5e5f78cef556@postgrespro.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
And what is the options you mentioned about?
Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
On 20.07.2016 21:02, Sameer Kumar wrote:
>
>
> On Thu, 21 Jul 2016, 1:17 a.m. Alex Ignatov, <a(dot)ignatov(at)postgrespro(dot)ru
> <mailto: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
> <mailto: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 | David G. Johnston | 2016-07-21 19:48:44 | Re: Array value from table as parameter |
Previous Message | Chris Travers | 2016-07-21 06:39:56 | Re: unique constraint with several null values |