Re: Proper format for pg_dump file date

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Proper format for pg_dump file date
Date: 2024-06-19 17:17:40
Message-ID: CANzqJaBODFMzxXMP=PwEVdW4hASGKfxa1r8iKiYbC4Q-3tnn5g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jun 19, 2024 at 1:14 PM Rich Shepard <rshepard(at)appl-ecosys(dot)com>
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,
>
> I use the default text format so restoration is by psql.
>

Perfectly valid for small databases, and copying tables from one instance
to another (though in that case, consider postgres_fdw).

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2024-06-19 17:38:24 Re: Proper format for pg_dump file date
Previous Message Ron Johnson 2024-06-19 17:15:07 Re: Proper format for pg_dump file date