Re: Moving a large DB (> 500GB) to another DB with different locale

From: Andreas Joseph Krogh <andreas(at)visena(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Moving a large DB (> 500GB) to another DB with different locale
Date: 2016-01-12 23:06:41
Message-ID: VisenaEmail.24.e011a1375902b6af.15238168cce@tc7-visena
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

På onsdag 13. januar 2016 kl. 00:03:18, skrev Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us
<mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us>>:
Andreas Joseph Krogh <andreas(at)visena(dot)com> writes:
> What about ORDER BY on columns without an index, would they sort correctly?

Sorting is sorting, it'll just use whatever collation is specified or
implied.

regards, tom lane
 
Right, so poking with pg_database.datcollate would take care of that so no
explicit COLLATE has to be issued on ORDER BY?
 
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andreas(at)visena(dot)com <mailto:andreas(at)visena(dot)com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>

 

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Saulo Merlo 2016-01-13 02:29:37 Query Questions - PostgreSQL
Previous Message Joshua D. Drake 2016-01-12 23:05:22 Re: WIP: CoC V5