Post

PostgreSQL 인코딩 확인

Posted Updated
By dejavuhyo 1 min read

1. 클라이언트 인코딩 확인

1

show client_encoding;

2. 서버 인코딩 확인

1

show server_encoding;

3. Database 인코딩 확인

1) 특정 DB

1

select pg_encoding_to_char(encoding) from pg_database where datname = 'postgres';

one-db

2) 전체 DB

1

select *, pg_encoding_to_char(encoding) from pg_database;

all-db

[출처 및 참고]

Database, PostgreSQL
postgresql-character-set character-set client-character-set server-character-set postgresql-인코딩 인코딩 클라이언트-인코딩 서버-인코딩 db-인코딩
This post is licensed under CC BY 4.0 by the author.