Skip to content

Instantly share code, notes, and snippets.

@ahmeti ahmeti/Postgresql-1.sql
Last active Jan 20, 2019

Embed
What would you like to do?
CREATE DATABASE test_db ENCODING='UTF-8' LC_COLLATE='tr_TR.UTF-8' TEMPLATE=template0;
CREATE TABLE "public"."cities" (
"id" int4 NOT NULL DEFAULT nextval('cities_id_seq'::regclass),
"country_id" int4 NOT NULL,
"name" varchar(100) COLLATE "pg_catalog"."tr_TR.UTF-8" NOT NULL
);
SELECT * FROM pg_collation;
# Mevcut paketleri listeliyoruz.
locale -a
# Yukarıdaki listede tr_TR veya tr_TR.UTF-8 yoksa ekliyoruz.
sudo locale-gen tr_TR
sudo locale-gen tr_TR.UTF-8
# Son olarak güncelleme yapıyoruz.
sudo update-locale
create collation "tr_TR.UTF-8" (LOCALE="tr_TR.UTF-8");
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.