On Thu, Apr 19, 2012 at 03:40:48PM +0530, MaheshKrishnan wrote: > So the problem is I want to restrict the values that can be entered in a > specific column of a specific shape file but haven't been able to do it.
You mean ".. of a specific table", not "shape file". > For example if there is a shapefile called Hydro_points and it has an > attribute column call Hydro_type I want only the values 1, 2 or 3 to be > entered here. ... > That table should not accept any other values You can use CHECK constraints on the table, with something like: ALTER TABLE mytable ADD CONSTRAINT only_one_two_three CHECK "Hydro_type" IN (1,2,3); (check the PostgreSQL reference manual to tweak and lear more) --strk; ,------o-. | __/ | Delivering high quality PostGIS 2.0 ! | / 2.0 | http://strk.keybit.net - http://vizzuality.com `-o------' _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
