[development] Postgres equivalent to SHOW TABLES

Ivan Sergio Borgonovo mail at webthatworks.it
Fri Sep 4 19:20:24 UTC 2009


On Fri, 4 Sep 2009 12:36:32 -0400
"Nancy Wichmann" <nan_wich at 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



More information about the development mailing list