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 D1C9FD1B532 for ; Fri, 17 Oct 2003 08:39:53 +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 90841-08 for ; Fri, 17 Oct 2003 05:39:24 -0300 (ADT) Received: from smtp016.mail.yahoo.com (smtp016.mail.yahoo.com [216.136.174.113]) by svr1.postgresql.org (Postfix) with SMTP id B6641D1B51B for ; Fri, 17 Oct 2003 05:39:21 -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 08:39:19 -0000 Message-ID: <007b01c3948a$de7800b0$7502a8c0@hdsc.com> Reply-To: "Kumar" From: "Kumar" To: "Jordan S. Jones" Cc: References: <005401c39474$db9cf640$7502a8c0@hdsc.com> <3F8F8A37.1010208@racistnames.com> Subject: Re: Object description at Client Window Date: Fri, 17 Oct 2003 14:14:17 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0070_01C394B8.F3A25020" 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/204 X-Sequence-Number: 15604 This is a multi-part message in MIME format. ------=_NextPart_000_0070_01C394B8.F3A25020 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi , Jordan, thanks for ur reply. But I am not asking that. I want to get all the column names of any table at the PgAdmin3 SQL Window.= To make it more clear, actually i wanted to send the table name as the inp= ut parameter for a function and expecting the column names, data types, etc= as the output. Is there any command or any system table from that I could query the column= names of a table (other than \d table name at the command prompt). Kumar ----- Original Message -----=20 From: Jordan S. Jones=20 To: Kumar=20 Cc: pgsql-sql@postgresql.org=20 Sent: Friday, October 17, 2003 11:50 AM Subject: Re: [SQL] Object description at Client Window give psql -E a try.. It will display any internal SQL commands that it us= es. 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=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 c= ommand 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_h= elptext in MS SQL server. Regards Kumar --=20 I am nothing but a poor boy. Please Donate.. https://www.paypal.com/xclick/business=3Dlist%40racistnames.com&no_note=3D1= &tax=3D0¤cy_code=3DUSD ------=_NextPart_000_0070_01C394B8.F3A25020 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi ,

Jordan, thanks for ur reply. But I am not asking=20 that.

I want to get all the column names of any table at= the=20 PgAdmin3 SQL Window. To make it more clear, actually i wanted to send the t= able=20 name as the input parameter for a function and expecting the column names, = data=20 types, etc as the output.

Is there any command or any system table from that I co= uld=20 query the column names of a table (other than \d table name at the command= =20 prompt).

Kumar

----- Original Message -----
Fro= m:=20 Jord= an S.=20 Jones
To: Kumar

Cc: pgsql-sql@postgresql.org
Sent: Friday, October 17, 2003 11:= 50=20 AM

Subject: Re: [SQL] Object descript= ion at=20 Client Window

give psql -E a try.. It will display any internal SQL comm= ands=20 that it uses.

Jordan S. Jones

Kumar wrote:

Dear Friends,

I am working with Postgres 7.3.4 on RH linux=20 7.2.

I could get into the command prompt to describe a t= able=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 interna= l=20 slash commands
       \g or terminate = with=20 semicolon to execute query
       \q t= o=20 quit

training=3D# \d=20 emp
          &nbs= p;    =20 Table "emp"
Column=20 |        =20 Type          |=20 Modifiers
--------+-----------------------+-----------
no&n= bsp;   =20 |=20 integer          &nbs= p;   =20 |
name   | character varying(20)=20 |
age    |=20 integer          &nbs= p;   =20 |

training=3D#

But I wanted to know whether this description could= be=20 availed at the command prompt. I am using PgAdmin3. I have checked the= =20 systems tables also. pg_tables can tell us only the table and the colum= ns=20 inside tables.

Any idea to share with me, please. I am looking for= =20 something like sp_helptext in MS SQL server.

Regards

Kumar

--=20 I am nothing but a poor boy. Please Donate.. https://www.paypal.com/xclick/business=3Dlist%40racistnames.com&= ;no_note=3D1&tax=3D0&currency_code=3DUSD

------=_NextPart_000_0070_01C394B8.F3A25020--