Re: php cant see new table!! - Mailing list pgsql-novice

From Michael Fuhr
Subject Re: php cant see new table!!
Date
Msg-id 20060218043942.GA69409@winnie.fuhr.org
Whole thread Raw
In response to php cant see new table!!  ("Sears, Jeremy" <Jeremy.Sears@CCRS.NRCan.gc.ca>)
List pgsql-novice
On Fri, Feb 17, 2006 at 10:55:10AM -0500, Sears, Jeremy wrote:
> I have sucessfully created a new table in a schema known as "st". I can view
> the contents of my database and see that this table exists. However when I
> attempt to connect to it via php, I get the following error:
>
> Warning: pg_query(): Query failed: ERROR: relation "st.iam" does not exist

Is the table name st.iam or st."IAM"?  If you don't understand the
difference then see the section about quoted identifiers in the
documentation:

http://www.postgresql.org/docs/8.1/interactive/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS

--
Michael Fuhr

pgsql-novice by date:

Previous
From: "Sears, Jeremy"
Date:
Subject: php cant see new table!!
Next
From: Andreas Seltenreich
Date:
Subject: Re: Ident authentication failed without su to user