Postgres Pro
Downloads
Home   >   mailing lists

Add 'CHECK( length(fieldname) > 0 )' to a field - Mailing list pgadmin-support

From Daniel Seichter
Subject Add 'CHECK( length(fieldname) > 0 )' to a field
Date
Msg-id s2b83918.014@HBC-N4.hbccr.de
Whole thread Raw
List pgadmin-support
Tree view 
Hello,

I have to let postgreSQL check the length of some fields in a database.
So I want to add the SQL Code "CHECK( length(fieldname) > 0 )" to some
fields so that the check will be executed during INSERT statement.
With the properties dialog I can't add the CHECK statement, so maybe it
isn't possible or I have to take a look to something. But to what?

Thank you in advance

Daniel Seichter

pgadmin-support by date:

Previous
From: Larry Morroni
Date:
Subject: Re: Scroll Cursor Bug?
Next
From: "Dave Page"
Date:
Subject: Re: Add 'CHECK( length(fieldname) > 0 )' to a field