4 Sep
2009
4 Sep
'09
9:20 p.m.
On Fri, 4 Sep 2009 12:36:32 -0400 "Nancy Wichmann" <nan_wich@bellsouth.net> wrote:
Does Postgres have an equivalent to MySql's SHOW TABLES? In particular "SHOW TABLES LIKE 'abc\_%'
Nancy E. Wichmann, PMP Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
For future reference... since you may need the output in a record set: - start psql with -E param and then use \d to see how pg actually retrieve those info - consider to consult information_schema. schema. I think it should be part of some SQL standard so it may even work on MySQL recent versions -- Ivan Sergio Borgonovo http://www.webthatworks.it