Re: could not open relation:no such file or directory

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@comcast.net