| From: | "tjk(at)tksoft(dot)com" <tjk(at)tksoft(dot)com> |
|---|---|
| To: | kdnostr(at)california(dot)sandia(dot)gov (Kristen Nostrand) |
| Cc: | pgsql-questions(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Finding out table names |
| Date: | 2000-04-19 20:22:48 |
| Message-ID: | 200004192022.NAA24872@uno.tksoft.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tim Johnson | 2000-04-20 01:28:01 | Re: GROUPING and ORDERING and CONFUSION |
| Previous Message | Kristen Nostrand | 2000-04-19 19:10:49 | Finding out table names |