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

Re: Dumping/Restoring with constraints?

From: "Phoenix Kiula" <phoenix(dot)kiula(at)gmail(dot)com>
To: "Tino Wildenhain" <tino(at)wildenhain(dot)de>
Cc: "PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Dumping/Restoring with constraints?
Date: 2008-08-27 23:51:57
Message-ID: e373d31e0808271651l6c7b99f0q960aaa5247b96b67@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
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

In response to

Responses

pgsql-admin by date

Next:From: RickDate: 2008-08-27 23:52:17
Subject: excluding tables
Previous:From: steveDate: 2008-08-27 21:31:30
Subject: Re: WAL files during a backup

pgsql-general by date

Next:From: William GarrisonDate: 2008-08-28 00:08:34
Subject: Re: Do I have a corrupted database?
Previous:From: Martijn van OosterhoutDate: 2008-08-27 22:04:50
Subject: Re: Do I have a corrupted database?

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