Обсуждение: displaying enum
Hi admins, I had created enum and forgotten what were the values. Is there any way to see what I created? Thanks
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
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
--- 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
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 > >
"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
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