Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 73C37650452 for ; Tue, 11 Nov 2008 22:27:25 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 26097-04 for ; Tue, 11 Nov 2008 22:27:21 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.cult.cu (mail.cult.cu [200.0.24.2]) by mail.postgresql.org (Postfix) with ESMTP id 492BF64FC2D for ; Tue, 11 Nov 2008 22:27:21 -0400 (AST) Received: from [200.0.25.90] (helo=ciego.cult.cu) by mail.cult.cu with esmtp (Exim 4.34) id 1L05VH-000FQ3-LA for pgsql-php@postgresql.org; Tue, 11 Nov 2008 22:30:47 -0400 Received: from atenea ([192.168.0.48]) by ciego.cult.cu (ciego.cult.cu) (MDaemon PRO v9.6.2) with ESMTP id md50000047660.msg for ; Mon, 10 Nov 2008 16:57:23 -0500 Message-ID: <001501c942e9$665772b0$3000a8c0@atenea> From: =?iso-8859-1?Q?F=E9lix_S=E1nchez_Rodr=EDguez?= To: "PostgreSQLPHP" Subject: See postgre tables from PHP code Date: Mon, 10 Nov 2008 05:04:15 +0100 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Spam-Processed: ciego.cult.cu, Mon, 10 Nov 2008 16:57:23 -0500 (not processed: message from valid local sender) X-MDRemoteIP: 192.168.0.48 X-Return-Path: fesanch@ciego.cult.cu X-Envelope-From: fesanch@ciego.cult.cu X-MDaemon-Deliver-To: pgsql-php@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200811/6 X-Sequence-Number: 3917 Hi everybody: I'm relatively new to PHP programming and I was recommended to use PostgreSQL as the site's database. However I haven't able to see my DB's tables from PHP. Here is my (very simple, I think) code: $pg = pg_connect("host=localhost port =5432 dbaname = ATM user=postgres password = mypassword"); pg_query($pg,"select nick,contrasenna,nombre,apellidos from usuarios"); Beside, I opened my PostgreSQL interface, called pgAdmin and run the same query inside the ATM database and the error was the same: "relation 'usuarios' was not found". It's like something else was needed to access the DB tables.