Re: Proper format for pg_dump file date

2024-06-19 Thread Rich Shepard
On Wed, 19 Jun 2024, Ron Johnson wrote: "Click select" stops at dash in some ssh clients, but not in others. That's what drives *my* decision making. (Also, "%F" is equivalent to "%Y-%m-%d".) Thanks, Ron. Rich

Re: Proper format for pg_dump file date

2024-06-19 Thread Ron Johnson
On Wed, Jun 19, 2024 at 1:14 PM Rich Shepard wrote: > On Wed, 19 Jun 2024, David G. Johnston wrote: > > > If you are doing a custom format dump using .sql as the extension is > > objectively wrong. it is correct if you are doing an sql dump, but those > > are generally best avoided. > > David, >

Re: Proper format for pg_dump file date

2024-06-19 Thread Ron Johnson
On Wed, Jun 19, 2024 at 11:55 AM Rich Shepard wrote: > Is the correct date format for pg_dump > -$(date +%Y-%m-%d).sql > or > --MM-DD.sql > "Click select" stops at dash in some ssh clients, but not in others. That's what drives *my* decision making. (Also, "%F" is equivalent

Re: Proper format for pg_dump file date

2024-06-19 Thread Rich Shepard
On Wed, 19 Jun 2024, David G. Johnston wrote: If you are doing a custom format dump using .sql as the extension is objectively wrong. it is correct if you are doing an sql dump, but those are generally best avoided. David, I use the default text format so restoration is by psql. Rich

Re: Proper format for pg_dump file date

2024-06-19 Thread David G. Johnston
On Wed, Jun 19, 2024 at 8:55 AM Rich Shepard wrote: > Is the correct date format for pg_dump > -$(date +%Y-%m-%d).sql > or > --MM-DD.sql > or something else? > > If you are doing a custom format dump using .sql as the extension is objectively wrong. it is correct if you are d

Re: Proper format for pg_dump file date [RESOLVED]

2024-06-19 Thread Rich Shepard
On Wed, 19 Jun 2024, Adrian Klaver wrote: That is your choice, whatever makes sense to you. Thank you, Adrian. Regards, Rich

Re: Proper format for pg_dump file date

2024-06-19 Thread Adrian Klaver
On 6/19/24 08:55, Rich Shepard wrote: Is the correct date format for pg_dump -$(date +%Y-%m-%d).sql or --MM-DD.sql or something else? That is your choice, whatever makes sense to you. TIA, Rich -- Adrian Klaver adrian.kla...@aklaver.com

Proper format for pg_dump file date

2024-06-19 Thread Rich Shepard
Is the correct date format for pg_dump -$(date +%Y-%m-%d).sql or --MM-DD.sql or something else? TIA, Rich