From: Jordan S. Jones <list@racistnames.com>
To: Kumar <sgnerd@yahoo.com.sg>
Cc: pgsql-sql@postgresql.org
Subject: Re: Object description at Client Window
Date: Fri, 17 Oct 2003 00:20:39 -0600
Message-ID: <3F8F8A37.1010208@racistnames.com> (raw)
In-Reply-To: <005401c39474$db9cf640$7502a8c0@hdsc.com>
References: <005401c39474$db9cf640$7502a8c0@hdsc.com>
give psql -E a try.. It will display any internal SQL commands that it uses.
Jordan S. Jones
Kumar wrote:
> Dear Friends,
>
> I am working with Postgres 7.3.4 on RH linux 7.2.
>
> I could get into the command prompt to describe a table structure.
>
> Welcome to psql, the PostgreSQL interactive terminal.
>
> Type: \copyright for distribution terms
> \h for help with SQL commands
> \? for help on internal slash commands
> \g or terminate with semicolon to execute query
> \q to quit
>
> training=# \d emp
> Table "emp"
> Column | Type | Modifiers
> --------+-----------------------+-----------
> no | integer |
> name | character varying(20) |
> age | integer |
>
> training=#
>
> But I wanted to know whether this description could be availed at the
> command prompt. I am using PgAdmin3. I have checked the systems tables
> also. pg_tables can tell us only the table and the columns inside tables.
>
> Any idea to share with me, please. I am looking for something like
> sp_helptext in MS SQL server.
>
> Regards
> Kumar
--
I am nothing but a poor boy. Please Donate..
https://www.paypal.com/xclick/business=list%40racistnames.com&no_note=1&tax=0¤cy_c...
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: list@racistnames.com, sgnerd@yahoo.com.sg
Subject: Re: Object description at Client Window
In-Reply-To: <3F8F8A37.1010208@racistnames.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox