Re: SHOW TABLES

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Re: SHOW TABLES
Дата
Msg-id e26500e9de9760d5433e8eafdb701c50@biglumber.com
обсуждение исходный текст
Ответ на Re: SHOW TABLES  ("Marc G. Fournier" <scrappy@hub.org>)
Список pgsql-hackers
-----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-----




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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: SHOW TABLES
Следующее
От: Aidan Van Dyk
Дата:
Сообщение: Re: cvs to git migration - keywords