On Fri, 4 Sep 2009 12:36:32 -0400 "Nancy Wichmann" <[email protected]> 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
