On Thu, Jul 21, 2016 at 7:14 PM Alex Ignatov <a.igna...@postgrespro.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.igna...@postgrespro.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@postgresql.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
