Re: SHOW , DESCRIBE, oh what's it called...

From: "Karl F(dot) Larsen" <k5di(at)zianet(dot)com>
To: Paul Fontenot <paul(at)code-slinger(dot)com>
Cc: PostgreSQL <pgsql-novice(at)postgresql(dot)org>
Subject: Re: SHOW , DESCRIBE, oh what's it called...
Date: 2000-06-15 12:05:24
Message-ID: Pine.LNX.4.10.10006150603540.770-100000@cannac.ampr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


In psql you show all tables with \d and you display a tables content with
the SQL call: SELECT * from <table name>;

On Tue, 13 Jun 2000, Paul Fontenot wrote:

> In MySQL you could issue a command:
>
> describe my_table_name;
>
> and it would come back with the columns, and their descriptions. What is the
> equivalent command in postgresql? I have looked everywhere and am probly
> just overlooking it by now.
>
> Thanks,
> Paul
>
>
>

Yours Truly,

- Karl F. Larsen, k5di(at)arrl(dot)net (505) 524-3303 -

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message ghaverla 2000-06-15 12:20:20 Re: [NOVICE] Maximum size before having to use BLOBs.
Previous Message Ryan Ho 2000-06-15 11:41:09 Maximum size before having to use BLOBs.