From: | Brew <brew(at)themode(dot)com> |
---|---|
To: | Félix Sánchez Rodríguez <fesanch(at)ciego(dot)cult(dot)cu> |
Cc: | PostgreSQLPHP <pgsql-php(at)postgresql(dot)org> |
Subject: | Re: See postgre tables from PHP code |
Date: | 2008-11-12 03:32:31 |
Message-ID: | 1d7288990811111932hf3c5f95kc77172124932e3d8@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php |
> 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.
From the postgres monitor (or maybe pgAdmin) do \d to see a list of
the tables available.
That is, in my case:
mode=> \d
List of relations
Schema | Name | Type | Owner
--------+-------------------------+----------+-------
public | accode | table | mode
public | categories | table | mode
public | key_requests | table | mode
public | listings | table | mode
public | listings_listing_id_seq | sequence | mode
public | query_benchmarks | table | mode
public | stored_strings | table | mode
public | uptime_benchmarks | table | mode
public | users | table | mode
public | users_user_id_seq | sequence | mode
(10 rows)
mode=>
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew McMillan | 2008-11-12 09:03:00 | Re: See postgre tables from PHP code |
PostgreSQL : 사설 토토 | Félix Sánchez Rodríguez | 2008-11-10 04:04:15 | PostgreSQL : 사설 토토 사이트 Code의 PostGre |