Search Postgresql Archives

psql pager, and searching for function arguments

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi all,

The tip beneath \df on psql's documentation page[0] advises the user:

| Tip: To look up functions taking arguments or returning values
| of a specific type, use your pager's search capability to scroll
| through the \df output.

(This tip was put in[1] as an alternative to having a real 'show me
all functions taking this datatype' command in psql.)

Well, OK, but I don't know how to tell for sure which pager is in use
when the PAGER environment variable is unset, as it seems to be by
default on my machines. And assuming I guess correctly ('less', it
appears), or am willing to specify a particular pager, is this tip
really usable for searching function arguments? I can see how to do
something terribly crude, by setting a particular 'grep' command to
temporarily act as a pager:

test=# \setenv PAGER 'grep internal'
test=# \df
 public | unaccent_init                 | internal         | internal
                             | normal
 public | unaccent_lexize               | internal         | internal,
internal, internal, internal | normal
test=# \setenv PAGER

but is there an easier way to "use your pager's search capability" I'm
missing, for some reasonable pager? The /pattern command for 'less'
isn't quite what I want, as it doesn't discard non-matching output.

Josh

[0] http://www.postgresql.org/docs/current/static/app-psql.html
[1] http://archives.postgresql.org/pgsql-hackers/2004-03/msg01290.php

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux