Skip site navigation (1) Skip section navigation (2)

Re: php cant see new table!!

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: "Sears, Jeremy" <Jeremy(dot)Sears(at)CCRS(dot)NRCan(dot)gc(dot)ca>
Cc: "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: php cant see new table!!
Date: 2006-02-18 04:39:42
Message-ID: (view raw or whole thread)
Lists: 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

Michael Fuhr

In response to

pgsql-novice by date

Next:From: Andreas SeltenreichDate: 2006-02-18 11:01:13
Subject: Re: Ident authentication failed without su to user
Previous:From: David GaudineDate: 2006-02-17 21:42:46
Subject: Re: Cloning databases using rsync

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group