Re: pg_dump without any SET command in header of output plain text sql file

Ok, thanks !

Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company

On 22.07.2016 06:49, Sameer Kumar wrote:
>
>
> On Thu, Jul 21, 2016 at 7:14 PM Alex Ignatov <a(dot)ignatov(at)postgrespro(dot)ru
> <mailto:a(dot)ignatov(at)postgrespro(dot)ru>> wrote:
>
> And what is the options you mentioned about?
>
>
> I stand corrected.
> I think the only ones you can avoid are OWNERSHIP and TABLESPACE
> commands.
>
> I think sed would be the best tool here.
>
> 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
>>
>
> --
> --
> 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
>