[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Why would queries fail with 'could not stat file' after CLUSTER?





On Tue, Apr 10, 2012 at 10:00 AM, Sashbeer Bhandari <sashbeer@xxxxxxxxx> wrote:
Hi
Good Morning,

I am using Postgresql DB 8.2 and my encoding is in SQL_ASCII ,. I want to convert it in UTF8, Please help me it.


Convert a database in the SQL_ASCII format into one of the UTF-8 format::

template1=# create database test with encoding='SQL_ASCII';

CREATE DATABASE

template1=# \connect test

You are now connected to database "test".

test=# create table a (x text);

CREATE TABLE

test=# insert into a values ('');

test=# select * from a;

x

--


(1 row)


test=# update pg_database set encoding =

pg_catalog.pg_char_to_encoding('UTF8') where datname='test';

UPDATE 1

test=# select * from a;

x

--


(1 row)


test=# \connect template1

You are now connected to database "template1".

template1=# \connect test

You are now connected to database "test".

test=# select * from a;

x

--


(1 row)


--Raghu


[Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

Powered by Linux