Hi,
Thanks for the response Michael. I have read over the documentation but I am
still unclear as to why php doesnt see my new table. I can see it in my
database, however php is unable to access it. I suspect that in the process
of creating the table I must have missed an essential command or somthing..
Can anyone suggest what Ive missed?
Thanks
Jeremy
this is the sql I used to creat the table:
CREATE TABLE "st"."IAM_appid" (
"id" INTEGER NOT NULL,
"application" CHAR(25) NOT NULL,
CONSTRAINT "IAM_appid_id_key" UNIQUE("id")
) WITH OIDS;
COMMENT ON COLUMN "st"."IAM_appid"."id"
IS 'application ID';
COMMENT ON COLUMN "st"."IAM_appid"."application"
IS 'description';
-----Original Message-----
* From: Michael Fuhr <mike ( at ) fuhr ( dot ) org>
* To: "Sears, Jeremy" <Jeremy ( dot ) Sears ( at ) CCRS ( dot ) NRCan (
dot ) gc ( dot ) ca>
* Subject: Re: php cant see new table!!
* Date: Fri, 17 Feb 2006 21:39:42 -0700
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-ID
ENTIFIERS
--
Michael Fuhr
