Query a list of tables

From: "Campbell, Lance" <lance(at)illinois(dot)edu>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Query a list of tables
Date: 2008-07-23 14:56:22
Message-ID: B10E6810AC2A2F4EA7550D072CDE8760CDDEBF@SAB-FENWICK.sab.uiuc.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

What is the SQL to do the following:

1) Return a list of all possible SCHEMA names within a database.

2) For a given SCHEMA return the list of all table names.

Thanks,

Lance Campbell

Project Manager/Software Architect

Web Services at Public Affairs

University of Illinois

217.333.0382

http://webservices.uiuc.edu <http://webservices.uiuc.edu/>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2008-07-23 15:02:03 Re: Query a list of tables
Previous Message Kevin Grittner 2008-07-23 14:39:42 Re: Welcome to the pgsql-admin list!