-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Greg Stark wrote:
> Well there's always \dtS and \dvS I don't see why typing \dfS is any harder.
>
> It would be nice for this to be more visible in the documentation and the \?
> output though. I've only just found it after months of pulling hair out
> looking for something just like it
Robert Treat replied:
> Wow you're not kidding. I've been using postgresql for I don't know how
> many years and I don't think I'd ever noticed that before. ISTM that we
> can make \df return only user function and \dfS return the system
> functions, and this would be consitant with how we handle other options.
> Just make sure to reword \? out put to make it clear that adding S will
> show system objects.
So it seems there are two possible solutions to the problem of segregating
user and system objects: change the order by or change the backslash operators.
I like the latter way, as it seems consistent with what we already are doing
(e.g. \dt \di) How about if we change the rest of the \d operators that support
custom objects to support the "S" option? I would affect the following:
\da \dc \dd \df \do \dT
I would rewrite the \? docs to make this more clear as well.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200409051221
-----BEGIN PGP SIGNATURE-----
iD8DBQFBOz0TvJuQZxSWSsgRAmdhAKCke2FfyB58/2dGoQF3Z+qmfNq3swCglmk9
aHa4jh1T2fzfCQ7XRQIlhLM=
=r5Qb
-----END PGP SIGNATURE-----
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
