Re: Describe a table

From: Tuna Chatterjee <tchatter(at)alert(dot)infoplease(dot)com>
To: Chris Boget <chris(at)wild(dot)net>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Describe a table
Date: 2002-11-13 16:59:22
Message-ID: 1037206769.1956.1.camel@steamer.infoplease.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

\d tablename

should do the trick.

take care,
-tuna

On Wed, 2002-11-13 at 11:55, Chris Boget wrote:
> I've looked in a bunch of places (include the describe.c as suggested
> in the FAQ; I'm just really rusty on my C and as such got nothing from
> the code) on how to 'describe' a table. In MySQL, I could simply use
> the command:
>
> desc tablename;
>
> What is the command in pgsql?
> I apologize for the stupid question but I've spent the last several hours
> looking for the stupid answer. :P
>
> thnx,
> Chris
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Lachlan Deck 2002-11-13 17:29:15 Help with JDBC connection...
Previous Message Chris Boget 2002-11-13 16:55:38 Describe a table