Re: [SQL] getting table info

From: neko(at)kredit(dot)sth(dot)szif(dot)hu
To: Marcio Macedo <marciom(at)conectiva(dot)com(dot)br>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] getting table info
Date: 1999-12-08 02:13:59
Message-ID: Pine.LNX.4.10.9912080311310.18622-100000@kredit.sth.szif.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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;(

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Fred Schoonewille 1999-12-08 08:12:32 select a part of a name
Previous Message Chris Griffin 1999-12-08 01:58:57 Re: [SQL] select distinct?