Setting locale for Chinese characters in Postgresql
You weren't far from finding it.
Here's the documentation you're looking for.

Yes you can define a specific locale for chosen columns (from 9.1 version).