On 10/10/2008 18:30, Sean wrote: > *I keep receiving the following when trying to select from a table in my > database. the Tables are there i see them in pgAdmin... > > *Warning*: pg_query_params() [function.pg-query-params > <http://localhost:8888/HH/function.pg-query-params>]: Query failed: > ERROR: relation "userroles" does not exist Would you have defined the table using quoted upper-case? PG folds names to lower-case unless you double quote them, so: test=# create table test(); CREATE TABLE test=# create table "Test"(); CREATE TABLE test=# \dt List of relations Schema | Name | Type | Owner --------+------+-------+---------- public | Test | table | postgres public | test | table | postgres (2 rows) Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@xxxxxx Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------
