On þri, 2006-12-26 at 02:43 -0800, karthik wrote:
> i facing a problem when trying to select values from a table in
> postgresql.
do you face this problem with any table or only from a
particular table?
> when i execute a query like "select title from itemsbytitle;"
what do you mean by 'a query like' ?
please show us the exact query
> i
> get error as
>
> Error:Could not open relation "itemsbytitle". no such file or
> directory.
please show us the exact error.
what version postgres are you using ?
are you using psql for your tests ?
if would be best is you cut'n'pasted a short psql session
that demonstrates the problem. something like:
+++++++++++++++++++
$ psql -d test
Welcome to psql 8.1.4, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
test=# create table blah (i int);
CREATE TABLE
test=# insert into blah values (1);
INSERT 0 1
test=# select * from blah;
i
---
1
(1 row)
test=# select * from blax;
ERROR: relation "blax" does not exist
++++++++++++++++++++++
this makes it easier for us to guess at what your problem is,
and simplifies reproducing it.
gnari
