Re: SHOW TABLES

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 />