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(at)turnstep(dot)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-----