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

2016-07-22 Thread Alex Ignatov
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 > wrote: And what is the options you mentioned about? I stand

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

2016-07-21 Thread Sameer Kumar
On Thu, Jul 21, 2016 at 7:14 PM Alex Ignatov 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.postgre

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

2016-07-21 Thread Alex Ignatov
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, > wrote: Hello everyone! I

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

2016-07-20 Thread Sameer Kumar
On Thu, 21 Jul 2016, 1:17 a.m. Alex Ignatov, 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 kn

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

2016-07-20 Thread Tom Lane
Alex Ignatov writes: > 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? No, but if all you want is the table data in a file, why not just use COPY? regards, tom lane -- Sent via pgsql-gen

[GENERAL] pg_dump without any SET command in header of output plain text sql file

2016-07-20 Thread Alex Ignatov
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? P.S. Yeah I know about sedding =) -- Alex Ignatov Postgres Professional: http://www.postgrespro.com The Russian Postgres Company -- Sent via pgsq