Re: SHOW TABLES

-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160


> Personally, I think this is somethign that should go into the backend ... 
> I'd like to be able to write perl scripts that talk to the backend without 
> having to remember all the various system tables I need to query / join to 
> get the same results as \d gives me in psql ... same for any interface 
> language, really ...

Perl, eh? Most (all?) interfaces already have their own methods, e.g. 

$dbh->tables();

Of course, they don't really provide all the information that \d does, 
but you shouldn't need to be querying the system catalogs directly 
for *any* interface, including psql (for most common tasks).

- -- 
Greg Sabino Mullane greg@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201007151357
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAkw/TBkACgkQvJuQZxSWSshuvACgtVpCav5qcl3nYsrsRdZ0vcT7
siUAoJaKkQ/RMAHcKCKJEyecjeEUhiQz
=2mS9
-----END PGP SIGNATURE-----