From: | "James Pang (chaolpan)" <chaolpan(at)cisco(dot)com> |
---|---|
To: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | database collation "C" and "C.LATIN1" |
Date: | 2023-03-09 08:22:37 |
Message-ID: | PH0PR11MB51911905C6D8C753E98504FCD6B59@PH0PR11MB5191.namprd11.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi,
We create one database with collate= "C.LATIN1", any difference between "C" and "C.LATIN1" ? database encoding is "LATIN1".
oid | collname | collnamespace | collowner | collprovider | collisdeterministic | collencoding | collcollate | collctype | collv
ersion
-------+------------------------+---------------+-----------+--------------+---------------------+--------------+------------------+------------------+------
-------
950 | C | 11 | 10 | c | t | -1 | C | C |
12328 | C.latin1 | 11 | 10 | c | t | 8 | C.latin1 | C.latin1
Thanks,
James
From | Date | Subject | |
---|---|---|---|
Next Message | Laurenz Albe | 2023-03-09 08:29:43 | Re: database collation "C" and "C.LATIN1" |
Previous Message | Tom Lane | 2023-03-08 18:42:46 | Re: PostgreSQL uses huge amount of memory |