Received: from as.tksoft.com (gyw.com [209.55.67.177] (may be forged)) by hub.org (8.9.3/8.9.3) with ESMTP id QAA17802; Wed, 19 Apr 2000 16:15:53 -0400 (EDT) (envelope-from tjk@tksoft.com) Received: (from tjk@tksoft.com) by uno.tksoft.com (8.8.8/8.8.8) id NAA24872; Wed, 19 Apr 2000 13:22:48 -0700 From: "tjk@tksoft.com" Message-Id: <200004192022.NAA24872@uno.tksoft.com> Subject: Re: Finding out table names To: kdnostr@california.sandia.gov (Kristen Nostrand) Date: Wed, 19 Apr 2000 13:22:48 -0700 (PDT) Cc: pgsql-questions@postgresql.org, pgsql-sql@postgresql.org In-Reply-To: <38FE04B9.CA6AFFFC@ca.sandia.gov> from "Kristen Nostrand" at Apr 19, 0 12:10:49 pm Content-Type: text X-Archive-Number: 200004/208 Kristen, Here's what I use. SELECT relname FROM pg_class WHERE relkind='r' and relname NOT LIKE 'pg_%' order by relname Obviously, if you have tables which start with "pg_," then this solution is not going to work. I don't know how orthodox this solution is, or whether there are serious problems with it. Maybe we'll find out now. Troy > > I'm doing some database programming using Java/JDBC. I'd > like to know how to find the table names contained in a > database/schema. Is there an SQL statement for doing that? > > Kristen >