Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 4966F2E476E for ; Fri, 18 Jan 2008 12:42:46 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 74725-06 for ; Fri, 18 Jan 2008 12:42:40 -0400 (AST) Received: from n6.bullet.ukl.yahoo.com (n6.bullet.ukl.yahoo.com [217.146.182.183]) by postgresql.org (Postfix) with SMTP id 0B7932E4632 for ; Fri, 18 Jan 2008 12:42:39 -0400 (AST) Received: from [217.12.4.215] by n6.bullet.ukl.yahoo.com with NNFMP; 18 Jan 2008 16:42:37 -0000 Received: from [216.252.122.217] by t2.bullet.ukl.yahoo.com with NNFMP; 18 Jan 2008 16:42:37 -0000 Received: from [69.147.84.107] by t2.bullet.sp1.yahoo.com with NNFMP; 18 Jan 2008 16:42:37 -0000 Received: from [127.0.0.1] by omp202.mail.sp1.yahoo.com with NNFMP; 18 Jan 2008 16:42:37 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 108520.24558.bm@omp202.mail.sp1.yahoo.com Received: (qmail 58759 invoked by uid 60001); 18 Jan 2008 16:42:37 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=HoV4LGlvNRq7LwW0+eddG6OEfXgTIq6FoI76JIwdjzkcOW7X9kYXG+j3Lxp6DfkOSC4wkkyyP0vYolY+07S45SauKleQfiThLbz97w3dFJ6jMu7cXt6MFATl9Z6g9wh+XclJyRPdOs9sqBqattKKzFSucVCOmQ6WBKB53vn6zfc=; X-YMail-OSG: .1S3Hf8VM1mOJDYyO4.SiQ8m_1UMeNhLMImwHTR7VV.q6gvO6GdtSyh9tM0BvxC8VcqI0BrNUIwoj.o5aRUownepxCVU2thA49TpCvzqrA.PO0EyzBzIeu4pJL0AOg-- Received: from [41.234.44.66] by web44807.mail.sp1.yahoo.com via HTTP; Fri, 18 Jan 2008 08:42:36 PST Date: Fri, 18 Jan 2008 08:42:36 -0800 (PST) From: "M.Khaled" Subject: Can not access the public schema To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1391543803-1200674556=:58096" Content-Transfer-Encoding: 8bit Message-ID: <940440.58096.qm@web44807.mail.sp1.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/213 X-Sequence-Number: 27987 --0-1391543803-1200674556=:58096 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hi, I had installed postgresql-8.1.9, But when I tried to run any sql statement like the following: (1)select * from ; or (2)select * from public.; on the query tool to access any table inside the public schema I got the following error: ERROR: relation "" does not exist or ERROR: relation "public." does not exist thought I am logging in with a superuser account. -Please advice. Thanks, Mohamed. --------------------------------- Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. --0-1391543803-1200674556=:58096 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
Hi,
I had installed postgresql-8.1.9, But when I tried to run any sql statement like the following:
(1)select * from <TableName>;
        or
(2)select * from public.<TableName>;
 
 on the query tool to access any table inside the public schema I got the following error:
ERROR:  relation "<TableName>" does not exist
                  or
ERROR:  relation "public.<TableName>" does not exist
thought I am logging in with a superuser account.
 
-Please advice.
 
Thanks,
Mohamed.


Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. --0-1391543803-1200674556=:58096--