Re: See postgre tables from PHP code

Поиск
Список
Период
Сортировка
От Brew
Тема Re: See postgre tables from PHP code
Дата
Msg-id 1d7288990811111932hf3c5f95kc77172124932e3d8@mail.gmail.com
обсуждение исходный текст
Ответ на See postgre tables from PHP code  (Félix Sánchez Rodríguez <fesanch@ciego.cult.cu>)
Список 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=>

В списке pgsql-php по дате отправления:

Предыдущее
От: Félix Sánchez Rodríguez
Дата:
Сообщение: See postgre tables from PHP code
Следующее
От: Andrew McMillan
Дата:
Сообщение: Re: See postgre tables from PHP code