From: | "Rommel B(dot) Abaya" <rommel(dot)abaya(at)ramcargroup(dot)com> |
---|---|
To: | Michael Teter <michael_teter(at)yahoo(dot)com> |
Cc: | pgsql-sql(at)hub(dot)org |
Subject: | Re: get table schema in psql? |
Date: | 2000-09-15 12:29:16 |
Message-ID: | 39C2161B.E10E9C9E@ramcargroup.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
type \d [tablename] at the psql console
Michael Teter wrote:
> how can I get the schema of a table in psql?
>
> in oracle I would do "desc tablename". I remember sql
> server and ingres having a similar facility.
>
> right now the only way I seem to be able to get the
> information is by using pgaccess.
>
> I realize the definition of the table is probably
> spread across the various pg_ system tables, but I'm
> thinking there must be some easier way to get the
> info.
>
> in particular, I'm after the list of columns, their
> data types and lengths, null/non-null, default values,
> and table indices.
>
> thanks,
> michael
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Mail - Free email you can access from anywhere!
> http://mail.yahoo.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-09-15 14:13:19 | Re: Error with DISTINCT |
Previous Message | Michael Teter | 2000-09-15 09:49:39 | Re: get table schema in psql? |