Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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.




Lance Campbell

Project Manager/Software Architect

Web Services at Public Affairs

University of Illinois

217.333.0382 <> 



pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group