Tagged Questions
3
votes
1answer
273 views
How to determine the collation of a table in PostgreSQL?
I want to script a check of the collations used on my tables in PostgreSQL, but googling for Postgresql detect collation is not working well for me, and the documentation is not making this an easy ...
4
votes
1answer
220 views
How do I resolve Postgresql error, 'no collation was derived for column “foo” with collatable type citext'?
Just recently I upgraded from Postgresql 8.4.11 to 9.1.3. I used pg_dump in the process. Now I'm getting an error:
ERROR: no collation was derived for column "vin" with collatable type citext
...
2
votes
1answer
335 views
Unicode support of PostgreSQL and its performance
How is the Unicode support of PostgreSQL?
If I want to save Unicode data does it have to go through the conversion process while storing and retrieving? If yes then what is the performance of such ...
