| 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: | Whole Thread | Raw Message | 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 |
| Previous Message | Félix Sánchez Rodríguez | 2008-11-10 04:04:15 | See postgre tables from PHP code |