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 <[email protected] <mailto:[email protected]>> 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, <[email protected] <mailto:[email protected]>> 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 ([email protected] <mailto:[email protected]>) 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
