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

From Tom Lane
Subject Re: Order in which tables are dumped
Date
Msg-id 4068.1532532492@sss.pgh.pa.us
Whole thread Raw
In response to Order in which tables are dumped  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: Order in which tables are dumped  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
Ron <ronljohnsonjr@gmail.com> writes:
> 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".

Looks like standard C-locale (ASCII) sort order to me ...

> Are there some other rules besides alphabetical sorting?

Dependencies can override the normal sort order, though a dependency
directly between two tables is rare.

            regards, tom lane


pgsql-general by date:

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