Re: pg_dump save command in output

2021-10-06 Thread Joao Miguel Ferreira
On Wed, Oct 6, 2021 at 11:40 AM Daniel Gustafsson wrote: > > On 6 Oct 2021, at 12:22, Laurenz Albe wrote: > > > > On Wed, 2021-10-06 at 10:44 +0100, Joao Miguel Ferreira wrote: > >> I would like to try that yes, it would be a pleasure but I have zero > knowledge on the dev tools, setups and proc

Re: pg_dump save command in output

2021-10-06 Thread Daniel Gustafsson
> On 6 Oct 2021, at 12:22, Laurenz Albe wrote: > > On Wed, 2021-10-06 at 10:44 +0100, Joao Miguel Ferreira wrote: >> I would like to try that yes, it would be a pleasure but I have zero >> knowledge on the dev tools, setups and processes required for that. >> >> If someone gives me some pointe

Re: pg_dump save command in output

2021-10-06 Thread Laurenz Albe
On Wed, 2021-10-06 at 10:44 +0100, Joao Miguel Ferreira wrote: > I would like to try that yes, it would be a pleasure but I have zero > knowledge on the dev tools, setups and processes required for that. > > If someone gives me some pointers I would love to try it. I'm a software > developer so

Re: pg_dump save command in output

2021-10-06 Thread Joao Miguel Ferreira
On Wed, Oct 6, 2021 at 10:33 AM Daniel Gustafsson wrote: > > On 3 Oct 2021, at 18:56, Joao Miguel Ferreira < > joao.miguel.c.ferre...@gmail.com> wrote: > > > is there a way to ask pg_dump to save a comment in the output file with > the full command it is executing ? > > I think this idea has some

Re: pg_dump save command in output

2021-10-06 Thread Daniel Gustafsson
> On 3 Oct 2021, at 18:56, Joao Miguel Ferreira > wrote: > is there a way to ask pg_dump to save a comment in the output file with the > full command it is executing ? I think this idea has some merit. Given the amount of switches for tailoring the dump that pg_dump has there is a point to kn

Re: pg_dump save command in output

2021-10-03 Thread Adrian Klaver
On 10/3/21 10:15 AM, Joao Miguel Ferreira wrote: I just wanted to save the command inside the SQL file to be able to "remember" it later. ideally I would open the file on some text editor and see the original pg_dump command on the few first lines, as a comment -- original command was: psq

Re: pg_dump save command in output

2021-10-03 Thread Karsten Hilbert
Am Sun, Oct 03, 2021 at 06:15:54PM +0100 schrieb Joao Miguel Ferreira: > I just wanted to save the command inside the SQL file to be able to > "remember" it later. ideally I would open the file on some text editor and > see the original pg_dump command on the few first lines, as a comment > > -- o

Re: pg_dump save command in output

2021-10-03 Thread Joao Miguel Ferreira
On Sun, Oct 3, 2021 at 6:03 PM Adrian Klaver wrote: > On 10/3/21 9:56 AM, Joao Miguel Ferreira wrote: > > Hello all, > > > > is there a way to ask pg_dump to save a comment in the output file with > > the full command it is executing ? > > No. > > What information is the comment trying to convey?

Re: pg_dump save command in output

2021-10-03 Thread Adrian Klaver
On 10/3/21 9:56 AM, Joao Miguel Ferreira wrote: Hello all, is there a way to ask pg_dump to save a comment in the output file with the full command it is executing ? No. What information is the comment trying to convey? Are you dumping in plain or custom format? thank you Joao -- Adr

pg_dump save command in output

2021-10-03 Thread Joao Miguel Ferreira
Hello all, is there a way to ask pg_dump to save a comment in the output file with the full command it is executing ? thank you Joao