Thread: Order in which tables are dumped

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?

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

On 07/25/2018 10:28 AM, Tom Lane wrote:
> 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 ...

I hate spreadsheets.  And gnu sort, and unicode...  :(

-- 
Angular momentum makes the world go 'round.

On 07/25/2018 10:43 AM, Vick Khera wrote:

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.

I'm tracking the progress of a very long backup, and the spreadsheet I using (and gnu sort, too, and IIRC Postgres' own ORDER BY) sort based on the current locale (en_US), whereas pg_dump sorts based on the C locale.  Thus, things aren't as I expected.

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.