Change collate postgresql

From: marcelo mendoza <jmarcelo(dot)mendoza(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Change collate postgresql
Date: 2020-08-18 20:00:19
Message-ID: CAPSkOeW8RNpaZfqVpwZz35dpL+8_gbc8dzmfV+AZOy9+wXEZfA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello everyone, I have the following list of databases, but in record 3 you
can see that the COLLATE has a space in the definition "en_US.UTF-
| 8" How can I fix this? Can I leave like this
without problem?

Regards

List of databases

-[ RECORD 1 ]-----+----------------------

Name | xxxxxxxxxx

Owner | xxxxxxx

Encoding | UTF8

Collate | en_US.UTF-8

Ctype | en_US.UTF-8

Access privileges |

-[ RECORD 2 ]-----+----------------------

Name | xxxxxxxxxx

Owner | xxxxxxx

Encoding | UTF8

Collate | en_US.UTF-8

Ctype | en_US.UTF-8

Access privileges |

-[ RECORD 3 ]-----+----------------------

Name | xxxxxxxx

Owner | xxxxxxx

Encoding | UTF8

Collate | en_US.UTF-

| 8

Ctype | en_US.UTF-8

Access privileges |

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Laurenz Albe 2020-08-19 05:59:52 Re: Change collate postgresql
Previous Message Akib Rhast 2020-08-11 18:13:10 Trouble running pgadmin container on heroku