Re: pg_dump save command in output - Mailing list pgsql-general

From Adrian Klaver
Subject Re: pg_dump save command in output
Date
Msg-id 0868132e-16d2-2d81-18c5-62cd7dc55666@aklaver.com
Whole thread Raw
In response to Re: pg_dump save command in output  (Joao Miguel Ferreira <joao.miguel.c.ferreira@gmail.com>)
List pgsql-general
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: psql -h some_host -p .....
> 
> 
>     Are you dumping in plain or custom format?
> 
> 
> plain (SQL)

A quick test here found that manually adding:

-- original command was: psql -h some_host -p .....

as:

-- Dumped by pg_dump version XX.x
-- original command was: psql -h some_host -p .....

at head of file did not infer with the restore.

No guarantees though.


> 
> 
>      >
>      > thank you
>      > Joao
>      >
> 
> 
>     -- 
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: pg_dump save command in output
Next
From: Shaozhong SHI
Date:
Subject: Re: PostgreSQL CHECK Constraint