Re: list of tables ? -update to question ...

Поиск
Список
Период
Сортировка
От Jan Wieck
Тема Re: list of tables ? -update to question ...
Дата
Msg-id 3D2DD0B0.3EE1E369@Yahoo.com
обсуждение исходный текст
Ответ на Re: list of tables ? -update to question ...  (Steve Brett <SBrett@e-mis.com>)
Список pgsql-sql
Steve Brett wrote:
> 
> sorry ... i didn't make myself clear ...
> 
> i have of course come across \dt before ...
> 
> what i meant was via sql as in 'select tablelist from <some pg sys table
> perhaps ?>'

What about:

SELECT * FROM pg_tables;


Jan

-- 

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #


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

Предыдущее
От: Manfred Koizar
Дата:
Сообщение: Re: [HACKERS] please help on query
Следующее
От: Manfred Koizar
Дата:
Сообщение: Re: [HACKERS] please help on query