Skip site navigation (1) Skip section navigation (2)

Database Encoding

From: <operationsengineer1(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Database Encoding
Date: 2005-04-16 11:22:01
Message-ID: 20050416112201.68772.qmail@web52408.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
i would like to make sure my template1 is encoded as
latin1.

1. how can i check the db encoding?  either a psql or
pgadmin method is fine.

2. how can i change it?

3. how can i change it in an existing database with
lots of tables (i can remove all data, if required).

i just went with the default when i set up the cygwin
version of pgsql - i'm not even sure what it is.

tia...

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

Responses

pgsql-novice by date

Next:From: Aarni RuuhimäkiDate: 2005-04-16 13:17:34
Subject: Re: Database Encoding
Previous:From: Bruno Wolff IIIDate: 2005-04-15 23:19:01
Subject: Re: query syntax question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group