Sure, you just need a constraint: create table test (info text constraint "no blanks" check (info<>'' and info<>' ') not null); CREATE TABLE insert into test (info) values (''); ERROR: new row for relation "test" violates CHECK constraint "no blanks" I'm not sure how to add constraints to already existing tables, so you might wanna do this in a test table, move your data over, then rename tables to swap in the new table. On Tue, 16 Sep 2003, S.P.Vimala wrote: > > > I think u are right, My code goes like this....... > > > This is what i do in my html page > $result = insert_user($userloginid,$username,$password,$usertype,$txtAddress, > $phoneno,$email); > > The function insert_user is like this. > > function insert_user($loginid,$username,$password,$usertype,$txtAddress,$phoneno,$email){ > if($dbhandle=get_dbconnection()) > { > $query="insert into vyapar_user values('". $loginid . > "','" . $username . "','" . $password . "','" . $usertype . "','" . > $txtAddress . "','" . $phoneno . "','" . $email . "')"; > $result=pg_exec($dbhandle,$query); > if(!result) > return null; > else > return $result; > } > } > > > I need to prevent '' as well as ' ' entry into the db which are also null > values may be not theoritically but in practice they are.... > > so any suggestions? > > > > > On Mon, 15 Sep 2003, S.P.Vimala wrote: > > > > > Hi, > > > > > > I have a table in postgresql db with the following description. > > > > > > - Table: vyapar_user > > > CREATE TABLE vyapar_user ( > > > loginid varchar(150) NOT NULL, > > > name varchar(150) NOT NULL, > > > "password" varchar(32) NOT NULL, > > > "type" varchar(10) NOT NULL, > > > address varchar(100) NOT NULL, > > > phone varchar(15), > > > email varchar(20), > > > creationdate date DEFAULT date('now'::text), > > > expriydate date DEFAULT (date('now'::text) + 360), > > > CONSTRAINT vyapar_user_pk PRIMARY KEY (loginid) > > > ) WITH OIDS; > > > > > > > > > If i try inserting NULL values from backend, then it gives me an > > > error. But thru php, its adds null values without any errors. Any idea > > > how to solve this issue..... > > > > I'll need to see some sample code. In my experience, PHP cannot insert > > NULLS into not null fields. > > > > Are you sure you're not inserting '' and thinking of it as NULL? They're > > not the same. > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 9: the planner will ignore your desire to choose an index scan if your > > joining column's datatypes do not match > > > >