RE: Default encoding in database

> > How does the output from "psql -l" look like?
>          List of databases
>   Database  |  Owner   | Encoding
> ------------+----------+-----------
>  template0  | postgres | SQL_ASCII
>  template1  | postgres | SQL_ASCII
> Jacob

I don't know why your template1 DB's encoding is SQL_ASCII, but you
need to change the encoding of the DB anyway.

try:

psql -c "update pg_database set encoding = 7 where datname =
'template1'" template1
--
Tatsuo Ishii