\dv and other lists SQL are unnecessarily complicated

From: Bug Finder <bugs(at)iamafreeman(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: \dv and other lists SQL are unnecessarily complicated
Date: 2002-04-18 22:44:42
Message-ID: 1019169882.1683.74.camel@home1.example.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello

Please forgive me if this has been discussed before.

\dv and other lists SQL are unnecessarily complicated.

They all seem to be based on the \d SQL

\dv currently uses

SELECT c.relname as "Name",
CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view' WHEN 'i'
THEN 'index' WHEN 'S' THEN 'sequence' WHEN 's' THEN 'special' END as
"Type",
u.usename as "Owner"
FROM pg_class c LEFT JOIN pg_user u ON c.relowner = u.usesysid
WHERE c.relkind IN ('v','')
AND c.relname !~ '^pg_'
ORDER BY 1;

when

SELECT c.relname as "Name", 'view' as "Owner"
FROM pg_class c LEFT JOIN pg_user u ON c.relowner = u.usesysid
WHERE c.relkind IN ('v','')
AND c.relname !~ '^pg_'
ORDER BY 1;

does the same thing

Is there a reason for this? Was it a cut'n'paste frenzy? not that there
is anything wrong with that - whatever gets it done.

Cheers,

Neil

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Curt Sampson 2002-04-18 23:20:06 Re: Questions on 7.2.1 query plan choices
Previous Message Roy Souther 2002-04-18 22:04:09 Paradox to PostgreSQL?