username - giselab
dbname - giselab
table name - countries
i created the country as follows :
giselab=> create table countries (id integer primary key, name varchar (20) not null);
it successfully created . Then i tried to add a geometry column to it as follows but i get the following error :
giselab=> select AddGeometryColumn ('giselab', 'countries', 'geom', -1, 'GEOMETRY', 2);
ERROR: Schema 'giselab' is not a valid schemaname
CONTEXT: SQL statement "SELECT AddGeometryColumn('', $1 , $2 , $3 , $4 , $5 , $6 )"
PL/pgSQL function "addgeometrycolumn" line 5 at SQL statement
i am using postgis 1.4.2 & postgres 8.4 on ubuntu.
what should i do ? all parametres passed to ddGeometryColumn seems correct. What is Schema , i thought its a Database name ?
pls help !!