On Fri, Apr 01, 2005 at 12:08:54PM -0000, Greg Sabino Mullane wrote: > Quoting Tom Lane: > > I thought the "S" suggestion was much better than this. > > > > Personally I am not unhappy with the existing behavior, because (unlike > > Greg I guess) I use \df and \do to look at system definitions all the > > time. However I'm willing to accept \dfS on the grounds of symmetry > > with the behavior for tables. I don't really want to put up with a less > > convenient behavior *and* a gratuitously different syntax.
FWIW, the pg_sysview project is doing user and all variants of system views, ie: pg_user_tables and pg_all_tables. I also wish there was a way to get just user functions. I like the idea of \dfS, and if you also wanted to be able to see all functions listed together, a \dfA (for all) doesn't seem unreasonable. -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?" ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
