Re: Dumping/Restoring with constraints?

Поиск
Список
Период
Сортировка
От Phoenix Kiula
Тема Re: Dumping/Restoring with constraints?
Дата
Msg-id e373d31e0808282253o13844c76odcd6f118fef4ff2e@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Dumping/Restoring with constraints?  (Andrew Sullivan <ajs@commandprompt.com>)
Ответы Re: Dumping/Restoring with constraints?  (Andrew Sullivan <ajs@commandprompt.com>)
Список pgsql-general
On 8/29/08, Andrew Sullivan <ajs@commandprompt.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

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: MySQL LAST_INSERT_ID() to Postgres
Следующее
От: Giorgio Valoti
Дата:
Сообщение: [Semi-OT]: How to customize locales?