Re: Order in which tables are dumped - Mailing list pgsql-general

From Vick Khera
Subject Re: Order in which tables are dumped
Date
Msg-id CALd+dcde1jbrv8CZzjW40fd0KjeSYtwOG84gpk7mAf-Fy=0H7w@mail.gmail.com
Whole thread Raw
In response to Order in which tables are dumped  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: Order in which tables are dumped
List pgsql-general
On Wed, Jul 25, 2018 at 11:15 AM, Ron <ronljohnsonjr@gmail.com> wrote:
Hi,

v8.4 if it matters.

It looked like the tables were being backed up in alphanumeric order, but now I see that table "docformat" is being dumped after "doc_image".

Are there some other rules besides alphabetical sorting?

Is there some concern about the order? Lower case f comes after _ in ascii.

The only time it could possibly matter is on restore when there are references for foreign keys, but on a restore those are all done after the data is restored. 

pgsql-general by date:

Previous
From: Dimitri Maziuk
Date:
Subject: Re: logical replication snapshots
Next
From: Ron
Date:
Subject: Re: Order in which tables are dumped