pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
describe
6+ messages / 4 participants
[nested] [flat]

* describe
@ 2005-02-11 20:23  Zuoxin.Wang@kp.org
  0 siblings, 2 replies; 6+ messages in thread

From: Zuoxin.Wang@kp.org @ 2005-02-11 20:23 UTC (permalink / raw)
  To: pgsql-admin; pgsql-admin-owner@postgresql.org

Hi,

Does anyone know psql command for  'describe'.

I tried show, but it did not wok.

Thanks.


Jason

^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: describe
@ 2005-02-11 20:41  Joshua D. Drake <jd@commandprompt.com>
  parent: Zuoxin.Wang@kp.org
  1 sibling, 1 reply; 6+ messages in thread

From: Joshua D. Drake @ 2005-02-11 20:41 UTC (permalink / raw)
  To: Zuoxin.Wang@kp.org; +Cc: pgsql-admin; pgsql-admin-owner@postgresql.org

Zuoxin.Wang@kp.org wrote:
> Hi,
> 
> Does anyone know psql command for  'describe'.

explain?


> 
> I tried show, but it did not wok.
> 
> Thanks.
> 
> 
> Jason
> 


-- 
Command Prompt, Inc., your source for PostgreSQL replication,
professional support, programming, managed services, shared
and dedicated hosting. Home of the Open Source Projects plPHP,
plPerlNG, pgManage,  and pgPHPtoolkit.
Contact us now at: +1-503-667-4564 - http://www.commandprompt.com

Attachments:

jd.vcf (text/x-vcard, 638B) download begin:vcard fn:Joshua D. Drake n:Drake;Joshua D. org:Command Prompt, Inc. adr:;;PO Box 215;Cascade Locks;Oregon;97014;USA email;internet:jd@commandprompt.com title:Consultant tel;work:503-667-4564 tel;fax:503-210-0334 note:Command Prompt, Inc. is the largest and oldest US based commercial PostgreSQL support provider. We provide the only commercially viable integrated PostgreSQL replication solution, but also custom programming, and support. We authored the book Practical PostgreSQL, the procedural language plPHP, and adding trigger capability to plPerl. x-mozilla-html:FALSE url:http://www.commandprompt.com/ version:2.1 end:vcard
^ permalink raw reply [nested|flat] 6+ messages in thread

* Re: describe
@ 2005-02-11 20:43  Michael Fuhr <mike@fuhr.org>
  parent: Zuoxin.Wang@kp.org
  1 sibling, 0 replies; 6+ messages in thread

From: Michael Fuhr @ 2005-02-11 20:43 UTC (permalink / raw)
  To: Zuoxin.Wang@kp.org; +Cc: pgsql-admin; pgsql-admin-owner@postgresql.org

On Fri, Feb 11, 2005 at 12:23:56PM -0800, Zuoxin.Wang@kp.org wrote:
> 
> Does anyone know psql command for  'describe'.

It would be helpful if you explained what "describe" is supposed
to do.  Maybe you're looking for the \d family of commands in psql?
See also the "System Catalogs" and "The Information Schema" chapters
in the documentation (the latter in 7.4 and later).

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: describe
@ 2005-02-11 20:49  Marc G. Fournier <scrappy@postgresql.org>
  parent: Joshua D. Drake <jd@commandprompt.com>
  0 siblings, 1 reply; 6+ messages in thread

From: Marc G. Fournier @ 2005-02-11 20:49 UTC (permalink / raw)
  To: Joshua D. Drake <jd@commandprompt.com>; +Cc: Zuoxin.Wang@kp.org; pgsql-admin; pgsql-admin-owner@postgresql.org

On Fri, 11 Feb 2005, Joshua D. Drake wrote:

> Zuoxin.Wang@kp.org wrote:
>> Hi,
>> 
>> Does anyone know psql command for  'describe'.
>
> explain?

I believe describe is mysql equivalent to our \d* commands ... no?

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: describe
@ 2005-02-11 20:58  Zuoxin.Wang@kp.org
  0 siblings, 0 replies; 6+ messages in thread

From: Zuoxin.Wang@kp.org @ 2005-02-11 20:58 UTC (permalink / raw)
  To: mike@fuhr.org; +Cc: pgsql-admin; pgsql-admin-owner@postgresql.org

thanks. \d is what I need.

Jason





Michael Fuhr <mike@fuhr.org>
02/11/2005 12:43 PM

 
        To:     Zuoxin Wang/CA/KAIPERM@Kaiperm
        cc:     pgsql-admin@postgresql.org, pgsql-admin-owner@postgresql.org
        Subject:        Re: [ADMIN] describe


On Fri, Feb 11, 2005 at 12:23:56PM -0800, Zuoxin.Wang@kp.org wrote:
> 
> Does anyone know psql command for  'describe'.

It would be helpful if you explained what "describe" is supposed
to do.  Maybe you're looking for the \d family of commands in psql?
See also the "System Catalogs" and "The Information Schema" chapters
in the documentation (the latter in 7.4 and later).

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/

^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: describe
@ 2005-02-11 21:04  Joshua D. Drake <jd@commandprompt.com>
  parent: Marc G. Fournier <scrappy@postgresql.org>
  0 siblings, 0 replies; 6+ messages in thread

From: Joshua D. Drake @ 2005-02-11 21:04 UTC (permalink / raw)
  To: Marc G. Fournier <scrappy@postgresql.org>; +Cc: Zuoxin.Wang@kp.org; pgsql-admin; pgsql-admin-owner@postgresql.org

Marc G. Fournier wrote:
> On Fri, 11 Feb 2005, Joshua D. Drake wrote:
> 
>> Zuoxin.Wang@kp.org wrote:
>>
>>> Hi,
>>>
>>> Does anyone know psql command for  'describe'.
>>
>>
>> explain?
> 
> 
> I believe describe is mysql equivalent to our \d* commands ... no?

Beats me. The only command I know of mysql is:

rpm -e mysql-server

Sincerely,

Joshua D. Drake


> 
> ----
> Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
> Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664


-- 
Command Prompt, Inc., your source for PostgreSQL replication,
professional support, programming, managed services, shared
and dedicated hosting. Home of the Open Source Projects plPHP,
plPerlNG, pgManage,  and pgPHPtoolkit.
Contact us now at: +1-503-667-4564 - http://www.commandprompt.com

Attachments:

jd.vcf (text/x-vcard, 638B) download begin:vcard fn:Joshua D. Drake n:Drake;Joshua D. org:Command Prompt, Inc. adr:;;PO Box 215;Cascade Locks;Oregon;97014;USA email;internet:jd@commandprompt.com title:Consultant tel;work:503-667-4564 tel;fax:503-210-0334 note:Command Prompt, Inc. is the largest and oldest US based commercial PostgreSQL support provider. We provide the only commercially viable integrated PostgreSQL replication solution, but also custom programming, and support. We authored the book Practical PostgreSQL, the procedural language plPHP, and adding trigger capability to plPerl. x-mozilla-html:FALSE url:http://www.commandprompt.com/ version:2.1 end:vcard
^ permalink raw reply [nested|flat] 6+ messages in thread


end of thread, other threads:[~2005-02-11 21:04 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-02-11 20:23 describe Zuoxin.Wang@kp.org
2005-02-11 20:41 ` Joshua D. Drake <jd@commandprompt.com>
2005-02-11 20:49   ` Marc G. Fournier <scrappy@postgresql.org>
2005-02-11 21:04     ` Joshua D. Drake <jd@commandprompt.com>
2005-02-11 20:43 ` Michael Fuhr <mike@fuhr.org>
2005-02-11 20:58 Re: describe Zuoxin.Wang@kp.org

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