X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 40F31537FE for ; Wed, 4 May 2005 09:55:14 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 49055-07 for ; Wed, 4 May 2005 12:55:06 +0000 (GMT) Received: from gizmo02bw.bigpond.com (gizmo02bw.bigpond.com [144.140.70.12]) by svr1.postgresql.org (Postfix) with SMTP id 42FBE536E6 for ; Wed, 4 May 2005 09:55:03 -0300 (ADT) Received: (qmail 14472 invoked from network); 4 May 2005 12:55:02 -0000 Received: from unknown (HELO BWMAM16.bigpond.com) (144.135.24.114) by gizmo02bw.bigpond.com with SMTP; 4 May 2005 12:55:02 -0000 Received: from cpe-144-137-160-77.qld.bigpond.net.au ([144.137.160.77]) by BWMAM16.bigpond.com(MAM REL_3_4_2a 264/43845451) with SMTP id 43845451; Wed, 04 May 2005 22:55:02 +1000 From: "Peter Schonefeld" To: Subject: ERROR: relation "mytable" does not exist Date: Wed, 4 May 2005 22:54:59 +1000 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.957 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, UPPERCASE_25_50 X-Spam-Level: * X-Archive-Number: 200505/78 X-Sequence-Number: 17507 Hi, I'm a postgres newbie trying to convert a small SQL Server database to postgres 8.0 . A typical table that i've created looks like this... CREATE TABLE "Country" ( "Id" int2 NOT NULL, "Name" varchar(50) NOT NULL, CONSTRAINT "PK_Country" PRIMARY KEY ("Id") ) WITHOUT OIDS; ALTER TABLE "Country" OWNER TO postgres; COMMENT ON TABLE "Country" IS 'listing of countries'; If i try SELECT * FROM Country, i get 'ERROR: relation "country" does not exist. Also, I'm looking for a good function reference. Any help would be appreciated. Regards Pete