Re: psql suggestion "select " offers nothing, can we get functions like "\df " - Mailing list pgsql-hackers

From Tom Lane
Subject Re: psql suggestion "select " offers nothing, can we get functions like "\df "
Date
Msg-id 1441980.1743704213@sss.pgh.pa.us
Whole thread Raw
In response to psql suggestion "select " offers nothing, can we get functions like "\df "  (Kirk Wolak <wolakk@gmail.com>)
Responses Re: psql suggestion "select " offers nothing, can we get functions like "\df "
List pgsql-hackers
Kirk Wolak <wolakk@gmail.com> writes:
>   But "select <tab>" does nothing.

What would you have it offer?  Every single column and function name
in the database?  Seems unlikely to be very helpful.

postgres=# select count(distinct attname) from pg_attribute;
 count 
-------
  1218
(1 row)

postgres=# select count(distinct proname) from pg_proc;
 count 
-------
  2787
(1 row)

That's with zero user-defined objects.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [fixed] Trigger test
Next
From: Andres Freund
Date:
Subject: Re: AIO v2.5