On Tuesday 26 December 2006 2:43 am, karthik wrote:
> hello,
>
> my name is karthik .
>
> i facing a problem when trying to select values from a table in
> postgresql.
>
> when i execute a query like "select title from itemsbytitle;" i
> get error as
>
> Error:Could not open relation "itemsbytitle". no such file or
> directory.
>
> can anybody help me to find an answer for this problem.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
I guess the first question is are you sure there is a table named
itemsbytitle? If so you may need to quote the table name-
SELECT title FROM "itemsbytitle";
See below for full explanation
http://www.postgresql.org/docs/8.2/interactive/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS
--
Adrian Klaver
aklaver(at)comcast(dot)net