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 41C07D1B524 for ; Fri, 17 Oct 2003 06:02:17 +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 65392-09 for ; Fri, 17 Oct 2003 03:01:47 -0300 (ADT) Received: from smtp012.mail.yahoo.com (smtp012.mail.yahoo.com [216.136.173.32]) by svr1.postgresql.org (Postfix) with SMTP id BFE57D1B51B for ; Fri, 17 Oct 2003 03:01:45 -0300 (ADT) Received: from ptil-138-190-chn.primus-india.net (HELO IVESIA67) (sgnerd@203.196.190.138 with login) by smtp.mail.vip.sc5.yahoo.com with SMTP; 17 Oct 2003 06:01:44 -0000 Message-ID: <005401c39474$db9cf640$7502a8c0@hdsc.com> Reply-To: "Kumar" From: "Kumar" To: "psql" Subject: Object description at Client Window Date: Fri, 17 Oct 2003 11:36:27 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0051_01C394A2.E6FDA060" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/202 X-Sequence-Number: 15602 This is a multi-part message in MIME format. ------=_NextPart_000_0051_01C394A2.E6FDA060 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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=3D# \d emp Table "emp" Column | Type | Modifiers --------+-----------------------+----------- no | integer | name | character varying(20) | age | integer | training=3D# But I wanted to know whether this description could be availed at the comma= nd 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_helpt= ext in MS SQL server. Regards Kumar ------=_NextPart_000_0051_01C394A2.E6FDA060 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
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= =20 structure.
 
Welcome to psql, the PostgreSQL interactive=20 terminal.
 
Type:  \copyright for distribution=20 terms
       \h for help with SQL=20 commands
       \? for help on internal sl= ash=20 commands
       \g or terminate with semic= olon=20 to execute query
       \q to quit<= /DIV>
 
training=3D# \d=20 emp
           &n= bsp;   =20 Table "emp"
 Column |       &nbs= p;=20 Type          |=20 Modifiers
--------+-----------------------+-----------
 no =    =20 |=20 integer           &n= bsp;  =20 |
 name   | character varying(20)=20 |
 age    |=20 integer           &n= bsp;  =20 |
 
training=3D#
 
But I wanted to know whether this description could be = availed=20 at the command prompt. I am using PgAdmin3. I have checked the systems tabl= es=20 also. pg_tables can tell us only the table and the columns inside=20 tables.
 
Any idea to share with me, please. I am looking for som= ething=20 like sp_helptext in MS SQL server.
 
Regards
Kumar

------=_NextPart_000_0051_01C394A2.E6FDA060--