X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id EF929D1B544
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 17 Oct 2003 06:21:23 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 72646-06
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 17 Oct 2003 03:20:54 -0300 (ADT)
Received: from racistnames.com (unknown [64.5.47.130])
	by svr1.postgresql.org (Postfix) with ESMTP id D0960D1B51B
	for <pgsql-sql@postgresql.org>; Fri, 17 Oct 2003 03:20:52 -0300 (ADT)
Received: from racistnames.com (12-254-249-119.client.attbi.com
	[12.254.249.119]) (authenticated)
	by racistnames.com (8.11.6/8.11.6) with ESMTP id h9H6KqG08793;
	Fri, 17 Oct 2003 02:20:52 -0400
Message-ID: <3F8F8A37.1010208@racistnames.com>
Date: Fri, 17 Oct 2003 00:20:39 -0600
From: "Jordan S. Jones" <list@racistnames.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
	rv:1.5) Gecko/20030925
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Kumar <sgnerd@yahoo.com.sg>
Cc: pgsql-sql@postgresql.org
Subject: Re: Object description at Client Window
References: <005401c39474$db9cf640$7502a8c0@hdsc.com>
In-Reply-To: <005401c39474$db9cf640$7502a8c0@hdsc.com>
Content-Type: multipart/alternative;
	boundary="------------080906010204070509000209"
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200310/203
X-Sequence-Number: 15603

This is a multi-part message in MIME format.
--------------080906010204070509000209
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

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&currency_code=USD


--------------080906010204070509000209
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
  <title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
give psql -E a try.. It will display any internal SQL commands that it
uses.<br>
<br>
Jordan S. Jones<br>
<br>
Kumar wrote:<br>
<blockquote type="cite"
 cite="mid005401c39474$db9cf640$7502a8c0@hdsc.com">
  <meta content="text/html; " http-equiv="Content-Type">
  <meta name="GENERATOR" content="MSHTML 6.00.2800.1264">
  <style></style>
  <div><font size="2">Dear Friends,</font></div>
  <div>&nbsp;</div>
  <div><font size="2">I am working with Postgres 7.3.4 on RH linux 7.2.</font></div>
  <div>&nbsp;</div>
  <div><font size="2">I could get into the command prompt to describe a
table structure.</font></div>
  <div>&nbsp;</div>
  <div><font size="2">Welcome to psql, the PostgreSQL interactive
terminal.</font></div>
  <div>&nbsp;</div>
  <div><font size="2">Type:&nbsp; \copyright for distribution terms<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \h for help with SQL commands<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \? for help on internal slash commands<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \g or terminate with semicolon to execute query<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \q to quit</font></div>
  <div>&nbsp;</div>
  <div><font size="2">training=# \d emp<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Table "emp"<br>
&nbsp;Column |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | Modifiers<br>
--------+-----------------------+-----------<br>
&nbsp;no&nbsp;&nbsp;&nbsp;&nbsp; | integer&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<br>
&nbsp;name&nbsp;&nbsp; | character varying(20) |<br>
&nbsp;age&nbsp;&nbsp;&nbsp; | integer&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</font></div>
  <div>&nbsp;</div>
  <div><font size="2">training=#</font></div>
  <div>&nbsp;</div>
  <div><font size="2">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.</font></div>
  <div>&nbsp;</div>
  <div><font size="2">Any idea to share with me, please. I am looking
for something like sp_helptext in MS SQL server.</font></div>
  <div>&nbsp;</div>
  <div><font size="2">Regards</font></div>
  <div><font size="2">Kumar</font></div>
</blockquote>
<br>
<br>
<pre cols="72" class="moz-signature">-- 
I am nothing but a poor boy. Please Donate..
<a class="moz-txt-link-freetext" href="https://www.paypal.com/xclick/business=list%40racistnames.com&no_note=1&tax=0&currency_code=USD">https://www.paypal.com/xclick/business=list%40racistnames.com&amp;no_note=1&amp;tax=0&amp;currency_code=USD</a></pre>
</body>
</html>

--------------080906010204070509000209--