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: 20060218043942.GA69409@winnie.fuhr.org (view raw or flat)
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
documentation:

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

-- 
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-2014 The PostgreSQL Global Development Group