From: | Patrik Kudo <kudo(at)partitur(dot)se> |
---|---|
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 09:42:24 |
Message-ID: | Pine.BSF.4.21.0009151141000.8114-100000@tb303.partitur.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi!
I think what you're looking for is
\d
and
\d name_of_table
You might also want to try
\?
for a list of all psql commands
Regards,
Patrik Kudo
ech`echo xiun|tr nu oc|sed 'sx\([sx]\)\([xoi]\)xo un\2\1 is xg'`ol
Känns det oklart? Fråga på!
On Fri, 15 Sep 2000, 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 | Michael Teter | 2000-09-15 09:49:39 | Re: get table schema in psql? |
Previous Message | Jerome Raupach | 2000-09-15 09:03:16 | Error with DISTINCT |