RE: Default encoding in database

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: jvm(at)gopinocchio(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: RE: Default encoding in database
Date: 2001-08-30 08:28:16
Message-ID: 20010830172816R.t-ishii@sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> > 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christian MEUNIER 2001-08-30 08:54:45 Too many open files in system FATAL2
Previous Message Gunnar Rønning 2001-08-30 08:25:22 Re: url to free text search stategies in postgresql?