Thread: Bug in psql/enum
Folks, 8.3's psql is ponderously unhelpful when getting the type description of an enum, so I'd like to propose a new column in the \dT output which can contain those values in an array format. Yes, I know it looks like a new feature, but it's really a bug fix. Cheers, David. -- David Fetter <david@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate
David Fetter <david@fetter.org> writes:
> 8.3's psql is ponderously unhelpful when getting the type description
> of an enum, so I'd like to propose a new column in the \dT output
> which can contain those values in an array format.
... and how wide is your screen, again?
regards, tom lane
On Sun, Jan 20, 2008 at 10:55:11PM -0500, Tom Lane wrote: > David Fetter <david@fetter.org> writes: > > 8.3's psql is ponderously unhelpful when getting the type > > description of an enum, so I'd like to propose a new column in the > > \dT output which can contain those values in an array format. > > ... and how wide is your screen, again? Excellent point. How about stacking them together one per line? I guess this would need to be one thing for Windows and another for Everybody Else. How about putting it in the \dT+ output? Cheers, David. -- David Fetter <david@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate
Added to psql TODO:
o Improve display if enums
http://archives.postgresql.org/pgsql-hackers/2008-01/msg00826.php
---------------------------------------------------------------------------
David Fetter wrote:
> Folks,
>
> 8.3's psql is ponderously unhelpful when getting the type description
> of an enum, so I'd like to propose a new column in the \dT output
> which can contain those values in an array format. Yes, I know it
> looks like a new feature, but it's really a bug fix.
>
> Cheers,
> David.
> --
> David Fetter <david@fetter.org> http://fetter.org/
> Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
> Skype: davidfetter XMPP: david.fetter@gmail.com
>
> Remember to vote!
> Consider donating to Postgres: http://www.postgresql.org/about/donate
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
-- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB
http://postgres.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +