Thread: getting table info

is there a way to retrieve the information about the table names and 
columns in a database ?

something like select * from database or something...

thx


-- 
--Marcio MacedoConectiva

"You're so boring boring boringalways tape machine recordingI've heard all this beforeI've heard all this beforeYour
emotionsmake you a monster."
 

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;(