Re: SHOW TABLES

Поиск
Список
Период
Сортировка
От Jesper Krogh
Тема Re: SHOW TABLES
Дата
Msg-id 4C3F3E13.8070700@krogh.cc
обсуждение исходный текст
Ответ на Re: SHOW TABLES  ("Marc G. Fournier" <scrappy@hub.org>)
Ответы Re: SHOW TABLES  ("Greg Sabino Mullane" <greg@turnstep.com>)
Список pgsql-hackers
On 2010-07-15 18:07, Marc G. Fournier wrote:<br /><span style="white-space: pre;">> On Thu, 15 Jul 2010, Thom Brown
wrote:<br/> > <br /> >> If it's only a psql problem, why implement it as SQL?  Is it just<br /> >> so
we'renot adding keywords specifically to psql?  In that case,<br /> >> it shouldn't support QUIT.<br /> > <br
/>> Personally, I think this is somethign that should go into the backend<br /> > ... I'd like to be able to
writeperl scripts that talk to the<br /> > backend without having to remember all the various system tables I<br />
>need to query / join to get the same results as \d gives me in psql<br /> > ... same for any interface language,
really...<br /></span><br /> Moving it into the backend (together with the other commands) would<br /> also solve this
usabillityissue:<br /><br /> WARNING:  You are connected to a server with major version 8.4,<br /> but your psql client
ismajor version 8.3.  Some backslash commands,<br /> such as \d, might not work properly.<br /><br /> testdb \d
testtable<br/> ERROR:  column "reltriggers" does not exist<br /> LINE 1: SELECT relhasindex, relkind, relchecks,
reltriggers,relhasr...<br />           <br /> --                                       ^<br /> Jesper<br /> 

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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: SHOW TABLES
Следующее
От: Brendan Jurd
Дата:
Сообщение: Re: reducing NUMERIC size for 9.1