Re: [SQL] getting table info - Mailing list pgsql-sql

From neko@kredit.sth.szif.hu
Subject Re: [SQL] getting table info
Date
Msg-id Pine.LNX.4.10.9912080311310.18622-100000@kredit.sth.szif.hu
Whole thread Raw
In response to getting table info  (Marcio Macedo <marciom@conectiva.com.br>)
List pgsql-sql
On Mon, 6 Dec 1999, Marcio Macedo wrote:

> is there a way to retrieve the information about the table names and 
> columns in a database ?
> 
> something like select * from database or something...

I think "SELECT relname FROM pg_class WHERE relkind='r'" is your friend.

--nek;(



pgsql-sql by date:

Previous
From: Chris Griffin
Date:
Subject: Re: [SQL] select distinct?
Next
From: Fred Schoonewille
Date:
Subject: select a part of a name