Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group