[postgis-users] change encoding of database

[Kralidis,Tom [Burlington]]

Hi,

Env:

Linux localhost 2.6.10-1.771_FC2 #1 Mon Mar 28 00:50:14 EST 2005 i686
i686 i386 GNU/Linux

PostgreSQL:

$ ./psql -V
psql (PostgreSQL) 8.0.3
contains support for command-line editing

PostGIS:

devgeodb=# select postgis_full_version();
                                        postgis_full_version
------------------------------------------------------------------------
---------------------------------
 POSTGIS="1.1.0CVS" GEOS="2.1.4" PROJ="Rel. 4.4.9, 29 Oct 2004"
USE_STATS DBPROC="0.3.0" RELPROC="0.3.0"
(1 row)

I have a database which I created and has a bunch of tables/data, both
spatial and aspatial.

As it happens, I messed up on the character encoding.

Questions:

1./ What's the best way to change the encoding of the database?  I'm
trying to avoid manually reloading things

2./ How will, if at all, spatial tables be affected?

Thanks

..Tom

=========================
Tom Kralidis
Senior Systems Scientist
Environment Canada
Tel: +01-905-336-4409
http://www.ec.gc.ca/