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

Re: Dumping/Restoring with constraints?

From: "Phoenix Kiula" <phoenix(dot)kiula(at)gmail(dot)com>
To: "Andrew Sullivan" <ajs(at)commandprompt(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Dumping/Restoring with constraints?
Date: 2008-08-29 05:53:28
Message-ID: e373d31e0808282253o13844c76odcd6f118fef4ff2e@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
On 8/29/08, Andrew Sullivan <ajs(at)commandprompt(dot)com> wrote:
>
> The latter should be in effect if your database encoding is UTF-8.
>  What's the database encoding?


My database encoding on BOTH the sides is UTF8. The dumped DB is UTF8.
The one I am importing into is also UTF8. So why is it showing me this
error? Do I also have to look at stuff like "collation"?

Also, how can I ensure that my dumped database on the server has only
UTF8 data? What constraint or function can I use?

Thanks

In response to

Responses

pgsql-admin by date

Next:From: Vishal AroraDate: 2008-08-29 10:12:53
Subject: Re: psql data restore not working
Previous:From: Daniel PuntonDate: 2008-08-29 00:26:44
Subject: psql data restore not working

pgsql-general by date

Next:From: Giorgio ValotiDate: 2008-08-29 06:39:54
Subject: [Semi-OT]: How to customize locales?
Previous:From: Tom LaneDate: 2008-08-29 04:45:20
Subject: Re: MySQL LAST_INSERT_ID() to Postgres

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