tags:

views:

2522

answers:

1
+1  Q: 

How can i change database encoding for a PostgreSQL database using sql or phpPgAdmin?

How can i change database encoding for a PostgreSQL database using sql or phpPgAdmin?

+8  A: 

You have to perform:

  1. database dump,
  2. delete database,
  3. create database with new encoding,
  4. import data from dump created in point 1.

Changing it on-the-fly isn't possible as it would require rewriting most of internal database data which is almost equal to recreating db way I described.

romke  2008-12-19 13:21:37
+1 I came here to say this.
Paul Tomblin  2008-12-19 13:24:20
i have a cpanel account and if i backup the database i will be able to restore only the content and not to recreate database with new encoding
daniels  2008-12-19 13:24:26
drop = delete, here's link to cpanel docs:http://www.cpanel.net/support/docs/11/cpanel/databases_delete_post.html
romke  2008-12-19 13:35:42

related questions

How do I (or can I) SELECT DISTINCT on multiple columns (postgresql)?
Is it possible to make a recursive SQL query ?
What does it mean when a PostgreSQL process is "idle in transaction"?
C# .NET + PostgreSQL
Possible to perform cross-database queries with postgres?
Cascading deletes in PostgreSQL
How to concatenate strings of a string field in a PostgreSQL 'group by' query?
Languages other than SQL in postgres
How to prevent Write Ahead Logging on just one table in PostgreSQL?
Using MS Access & ODBC to connect to a remote PostgreSQL
Reasons for SQL differences
PostgreSQL perfomance monitoring tool
How do you use script variables in PostgreSQL?
MySQL vs PostgreSQL for Web Applications
joining latest of various usermetadata tags to user rows
Good strategy for leaving an audit trail/change history for DB applications?
PostgreSQL: GIN or GiST indexes?
Migrating from MySQL to PostgreSQL
What's the preferred way to connect to a postgresql database from PHP?
Use for the phppgadmin Reports Database?
Recommendation for a PostgreSQL Programming Tutorial?
SQL Case Statement Syntax?
What language do you use for Postgresql triggers and stored procedures?
String literals and escape characters in postgresql
Python and MySQL