From: Phoenix Kiula <phoenix.kiula@gmail.com>
To: Tino Wildenhain <tino@wildenhain.de>
Cc: PG-General Mailing List <pgsql-general@postgresql.org>
Subject: Re: Dumping/Restoring with constraints?
Date: Thu, 28 Aug 2008 07:51:57 +0800
Message-ID: <e373d31e0808271651l6c7b99f0q960aaa5247b96b67@mail.gmail.com> (raw)
In-Reply-To: <48B5BC2A.5070104@wildenhain.de>
References: <e373d31e0808270619uba31c8eodc2c85662b85140a@mail.gmail.com>
<48B5BC2A.5070104@wildenhain.de>
Is there a mechanism to check exactly which row may have characters
that are not UTF8? I am trying with this kind of a command:
select id from employee
where modify_date between '2008-03-01' and '2008-07-01'
and joint_field_of_name_etc <> convert(joint_field_of_name_etc, 'UTF8')
This is of course not the best way of doing so. Is there a better
system-provided way of checking for rows that may not be UTF8? Or to
even have a constraint to this effect, to disallow any non-UTF8 data
from getting in there?
Thanks
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: phoenix.kiula@gmail.com, tino@wildenhain.de, pgsql-general@postgresql.org
Subject: Re: Dumping/Restoring with constraints?
In-Reply-To: <e373d31e0808271651l6c7b99f0q960aaa5247b96b67@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox