From: | Jie Liang <jliang(at)ipinc(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 21:29:26 |
Message-ID: | 39C294B6.2EB894AF@ipinc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi, there,
You just need type
psql> \d tablename
use
\? to get help
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/
--
Jie LIANG
Internet Products Inc.
10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873
jliang(at)ipinc(dot)com
www.ipinc.com
From | Date | Subject | |
---|---|---|---|
Next Message | Jie Liang | 2000-09-15 21:36:38 | Re: Error with DISTINCT |
Previous Message | Kyle | 2000-09-15 15:55:57 | New operators |