pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedHow to do this in pgsql?
3+ messages / 3 participants
[nested] [flat]
* How to do this in pgsql?
@ 2000-04-20 04:07 Larry ganga giri <linuxfan@england.com>
0 siblings, 2 replies; 3+ messages in thread
From: Larry ganga giri @ 2000-04-20 04:07 UTC (permalink / raw)
To: pgsql-sql-owner+M349@hub.org; +Cc: pgsql-sql
Hi,
I need to
*Describe the table structure.
Tried Desc <tab-name> as in oracle.
But it failed.
*Create an user-defined type in pgsql.
can anybody help me pleez?
thanks,
Larry.
__________________________________________________________________
Get your own free England E-mail address at http://www.england.com
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: How to do this in pgsql?
@ 2000-04-20 10:29 Michael A. Chase <mchase@ix.netcom.com>
parent: Larry ganga giri <linuxfan@england.com>
1 sibling, 0 replies; 3+ messages in thread
From: Michael A. Chase @ 2000-04-20 10:29 UTC (permalink / raw)
To: pgsql-sql-owner+M349@hub.org; Larry ganga giri <linuxfan@england.com>; +Cc: pgsql-sql
Run 'perldoc DBI' and 'perldoc DBD::Pg' to read the fine manuals to see how
to do this under DBI. I'm sure Postgress has some fine manuals, too.
Describe is a SQL*Plus command, not a SQL command.
--
Mac :})
** I may forward private database questions to the DBI mail lists. **
----- Original Message -----
From: "Larry ganga giri" <linuxfan@england.com>
To: <pgsql-sql-owner+M349@hub.org>
Cc: <pgsql-sql@postgresql.org>
Sent: Wednesday, April 19, 2000 9:07 PM
Subject: How to do this in pgsql?
> I need to
> *Describe the table structure.
> Tried Desc <tab-name> as in oracle.
> But it failed.
> *Create an user-defined type in pgsql.
>
> can anybody help me pleez?
^ permalink raw reply [nested|flat] 3+ messages in thread
* RE: How to do this in pgsql?
@ 2000-04-20 23:52 Michael S. Kelly <michaelk@axian.com>
parent: Larry ganga giri <linuxfan@england.com>
1 sibling, 0 replies; 3+ messages in thread
From: Michael S. Kelly @ 2000-04-20 23:52 UTC (permalink / raw)
To: Larry ganga giri <linuxfan@england.com>; pgsql-sql-owner+M349@hub.org; +Cc: pgsql-sql
Hi Larry,
I'm something of a newbie to PostgreSQL myself, but I just happened to be
reading the section in Bruce Momjian's book that discusses how to display a
table's structure in psql. The command is "\d <table_name>".
The user-defined types will be in chapter 16, which is, as yet, unwritten.
But the Programmer's Guide seems to discuss this topic.
If you haven't looked at Momjian's book yet, I highly recommend you download
a copy.
http://www.postgresql.org/docs/awbook.html
Good luck,
-=michael=-
-----Original Message-----
From: Larry ganga giri [mailto:linuxfan@england.com]
Sent: Wednesday, April 19, 2000 9:08 PM
To: pgsql-sql-owner+M349@hub.org
Cc: pgsql-sql@postgresql.org
Subject: How to do this in pgsql?
Hi,
I need to
*Describe the table structure.
Tried Desc <tab-name> as in oracle.
But it failed.
*Create an user-defined type in pgsql.
can anybody help me pleez?
thanks,
Larry.
__________________________________________________________________
Get your own free England E-mail address at http://www.england.com
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2000-04-20 23:52 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-04-20 04:07 How to do this in pgsql? Larry ganga giri <linuxfan@england.com>
2000-04-20 10:29 ` Michael A. Chase <mchase@ix.netcom.com>
2000-04-20 23:52 ` Michael S. Kelly <michaelk@axian.com>
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