Re: Proper format for pg_dump file date

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Proper format for pg_dump file date
Date: 2024-06-19 16:14:41
Message-ID: CAKFQuwZO_J+LhHK6iL_AB2FzFickN=Z8ELb4T5spivatoUpTjQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jun 19, 2024 at 8:55 AM Rich Shepard <rshepard(at)appl-ecosys(dot)com>
wrote:

> Is the correct date format for pg_dump
> <filename>-$(date +%Y-%m-%d).sql
> or
> <filename>-YYYY-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 doing an sql dump, but those
are generally best avoided.

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ayush Vatsa 2024-06-19 16:46:44 Re: Seeking Clarification on Function Definitions in PostgreSQL Extensions
Previous Message Rich Shepard 2024-06-19 16:11:16 Re: Proper format for pg_dump file date [RESOLVED]