>
> Rode o seguinte SQL:
> SELECT name, setting FROM pg_settings
>   WHERE name ~ 'encoding|^lc_|version';
> e veja os encodings em uso.


"client_encoding";"UNICODE"
"lc_collate";"Portuguese_Brazil.1252"
"lc_ctype";"Portuguese_Brazil.1252"
"lc_messages";"Portuguese_Brazil"
"lc_monetary";"Portuguese_Brazil"
"lc_numeric";"Portuguese_Brazil"
"lc_time";"Portuguese_Brazil"
"server_encoding";"UTF8"
"server_version";"8.3.0"
"server_version_num";"80300"




SELECT datname, pg_encoding_to_char(encoding) FROM pg_database;
> lista o encoding de cada um de seus bancos de dados.


"template0";"UTF8"
"postgres";"UTF8"
"template1";"UTF8"
"sgda";"UTF8"

Pode me dizer se isto está correto ?


-- 
Silfar Goulart
_______________________________________________
pgbr-geral mailing list
pgbr-geral@listas.postgresql.org.br
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Responder a