pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feeddisplaying enum
6+ messages / 5 participants
[nested] [flat]
* displaying enum
@ 2008-09-22 13:20 Jagadeesh <mnjagadeesh@gmail.com>
0 siblings, 2 replies; 6+ messages in thread
From: Jagadeesh @ 2008-09-22 13:20 UTC (permalink / raw)
To: pgsql-admin
Hi admins,
I had created enum and forgotten what were the values. Is there any
way to see what I created?
Thanks
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: displaying enum
@ 2008-09-22 14:53 chirag.dave@gmail.com
parent: Jagadeesh <mnjagadeesh@gmail.com>
1 sibling, 1 reply; 6+ messages in thread
From: chirag.dave@gmail.com @ 2008-09-22 14:53 UTC (permalink / raw)
To: Jagadeesh <mnjagadeesh@gmail.com>; +Cc: pgsql-admin
Assuming you are are running 8.3, you can do this:
SELECT a.typname,b.enumlabel from pg_type a , pg_enum b where
a.oid=b.enumtypid and a.typname='NAME_OF_ENUM';
Chirag Dave
Afilias
On Mon, Sep 22, 2008 at 9:20 AM, Jagadeesh <mnjagadeesh@gmail.com> wrote:
> Hi admins,
>
> I had created enum and forgotten what were the values. Is there any
> way to see what I created?
>
> Thanks
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: displaying enum
@ 2008-09-22 15:56 Lennin Caro <lennin.caro@yahoo.com>
parent: Jagadeesh <mnjagadeesh@gmail.com>
1 sibling, 1 reply; 6+ messages in thread
From: Lennin Caro @ 2008-09-22 15:56 UTC (permalink / raw)
To: pgsql-admin@postgresql.org, Jagadeesh <mnjagadeesh@gmail.com>
--- On Mon, 9/22/08, Jagadeesh <mnjagadeesh@gmail.com> wrote:
> From: Jagadeesh <mnjagadeesh@gmail.com>
> Subject: [ADMIN] displaying enum
> To: pgsql-admin@postgresql.org
> Date: Monday, September 22, 2008, 1:20 PM
> Hi admins,
>
> I had created enum and forgotten what were the values. Is
> there any
> way to see what I created?
>
> Thanks
what version of postgresql you have?
try this query
select * from pg_type a,pg_enum b
where a.oid = b.enumtypid
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: displaying enum
@ 2008-09-22 16:29 Scott Marlowe <scott.marlowe@gmail.com>
parent: chirag.dave@gmail.com
0 siblings, 1 reply; 6+ messages in thread
From: Scott Marlowe @ 2008-09-22 16:29 UTC (permalink / raw)
To: chirag.dave@gmail.com; +Cc: Jagadeesh <mnjagadeesh@gmail.com>; pgsql-admin
Does anyone know if there's plans afoot to add this to 8.4 psql as a
\d command? Seems it could be useful. Heck, if there was just a bit
more data in the \dT output we'd be set.
On Mon, Sep 22, 2008 at 8:53 AM, <chirag.dave@gmail.com> wrote:
> Assuming you are are running 8.3, you can do this:
>
> SELECT a.typname,b.enumlabel from pg_type a , pg_enum b where
> a.oid=b.enumtypid and a.typname='NAME_OF_ENUM';
>
> Chirag Dave
> Afilias
>
>
> On Mon, Sep 22, 2008 at 9:20 AM, Jagadeesh <mnjagadeesh@gmail.com> wrote:
>>
>> Hi admins,
>>
>> I had created enum and forgotten what were the values. Is there any
>> way to see what I created?
>>
>> Thanks
>>
>> --
>> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin
>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: displaying enum
@ 2008-09-23 03:15 Tom Lane <tgl@sss.pgh.pa.us>
parent: Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Tom Lane @ 2008-09-23 03:15 UTC (permalink / raw)
To: Scott Marlowe <scott.marlowe@gmail.com>; +Cc: chirag.dave@gmail.com, Jagadeesh <mnjagadeesh@gmail.com>; pgsql-admin
"Scott Marlowe" <scott.marlowe@gmail.com> writes:
> Does anyone know if there's plans afoot to add this to 8.4 psql as a
> \d command? Seems it could be useful. Heck, if there was just a bit
> more data in the \dT output we'd be set.
Done already, see \dT+ ...
regards, tom lane
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: displaying enum
@ 2008-09-23 03:41 Jagadeesh <mnjagadeesh@gmail.com>
parent: Lennin Caro <lennin.caro@yahoo.com>
0 siblings, 0 replies; 6+ messages in thread
From: Jagadeesh @ 2008-09-23 03:41 UTC (permalink / raw)
To: pgsql-admin
On Sep 22, 8:56 pm, lennin.c...@yahoo.com (Lennin Caro) wrote:
> --- On Mon, 9/22/08, Jagadeesh <mnjagade...@gmail.com> wrote:
>
> > From: Jagadeesh <mnjagade...@gmail.com>
> > Subject: [ADMIN] displaying enum
> > To: pgsql-ad...@postgresql.org
> > Date: Monday, September 22, 2008, 1:20 PM
> > Hi admins,
>
> > I had created enum and forgotten what were the values. Is
> > there any
> > way to see what I created?
>
> > Thanks
>
> what version of postgresql you have?
>
> try this query
>
> select * from pg_type a,pg_enum b
> where a.oid = b.enumtypid
>
> --
> Sent via pgsql-admin mailing list (pgsql-ad...@postgresql.org)
> To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-admin
Thanks for helping me.
Here is the postres server version I am using.
server_version
----------------
8.3.1
Your query is not describing enum. but I think its listing meta info
about the enums.
Thanks
Jagadeesh
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2008-09-23 03:41 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-09-22 13:20 displaying enum Jagadeesh <mnjagadeesh@gmail.com>
2008-09-22 14:53 ` chirag.dave@gmail.com
2008-09-22 16:29 ` Scott Marlowe <scott.marlowe@gmail.com>
2008-09-23 03:15 ` Tom Lane <tgl@sss.pgh.pa.us>
2008-09-22 15:56 ` Lennin Caro <lennin.caro@yahoo.com>
2008-09-23 03:41 ` Jagadeesh <mnjagadeesh@gmail.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