Re: Moving a large DB (> 500GB) to another DB with different locale
På onsdag 13. januar 2016 kl. 00:03:18, skrev Tom Lane <tgl@sss.pgh.pa.us>:
Andreas Joseph Krogh <andreas@visena.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
Вложения
В списке pgsql-general по дате отправления: