[postgis-users] change encoding of database

[Paul Ramsey]

You'll have to dump/restore, but it should not be painful (I am  
pretty sure):

1 - create newdatabase with desired encoding
2 - pg_dump olddatabase | psql newdatabase

Should be that easy (I hope!)

P

On Dec 1, 2005, at 6:47 PM, Kralidis,Tom [Burlington] wrote:

>
> 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/
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users