Re: [SQL] Question about schema - Mailing list pgsql-sql

From G. Anthony Reina
Subject Re: [SQL] Question about schema
Date
Msg-id 365B623C.2B03BB2E@nsi.edu
Whole thread Raw
In response to Question about schema  (dbms dbms <dbmss@yahoo.com>)
List pgsql-sql
If you just want to know what your table looks like, try:

select * from pg_class;

To just get the class names, try select relname from pg_class;

I'm pretty sure that you can execute this from psql c-commands.


-Tony

pgsql-sql by date:

Previous
From: dbms dbms
Date:
Subject: Question about schema
Next
From: Vadim Mikheev
Date:
Subject: Re: [HACKERS] Re: [SQL] cursor and update + view