Postgres Pro
Downloads
Home   >   mailing lists

database collation "C" and "C.LATIN1" - Mailing list pgsql-admin

From James Pang (chaolpan)
Subject database collation "C" and "C.LATIN1"
Date
Msg-id PH0PR11MB51911905C6D8C753E98504FCD6B59@PH0PR11MB5191.namprd11.prod.outlook.com
Whole thread Raw
Responses Re: database collation "C" and "C.LATIN1"  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-admin
Tree view

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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgreSQL uses huge amount of memory
Next
From: Laurenz Albe
Date:
Subject: Re: database collation "C" and "C.LATIN1"