Re: question on the information_schema

Поиск
Список
Период
Сортировка
От bricklen
Тема Re: question on the information_schema
Дата
Msg-id CAGrpgQ_Mg60DOdAS6VaNr5Q-DKFysB3x3Y1Skx8qR6AGfnHUBA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: question on the information_schema  (Salvatore Barone <salvator.barone@gmail.com>)
Список pgsql-admin

On Fri, Aug 23, 2013 at 8:02 AM, Salvatore Barone <salvator.barone@gmail.com> wrote:
On 23/08/2013 16:57, bricklen wrote:
select *
from information_schema.columns
where table_schema not in ('information_schema','pg_catalog')
Both queries, whether to send as user "ssaa", ie the user that I use daily, return an empty table. If sending as user "postgres" instead, they return the correct list of columns.

See David Johnston's response, I think that might be the reason why you are not seeing anything (no tables to show columns of).

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

Предыдущее
От: Salvatore Barone
Дата:
Сообщение: Re: question on the information_schema
Следующее
От: Salvatore Barone
Дата:
Сообщение: Re: question on the information_schema