Search Postgresql Archives

Re: Viewing non-system objects in psql

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

 



On Thu, Jun 16, 2005 at 07:54:29PM -0000, Greg Sabino Mullane wrote:
> 
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> I recently submitted a patch that makes all the database objects
> behave in the same way as far as the backslash psql commands.
> Currently, tables work like this: \dt lists all non-system tables in
> your path, while \dtS shows only the system tables. The idea is to
> expand that functionality to other database objects, e.g. functions.
> Currently, \df will show you a list of *all* functions, including
> the system ones. Since there are currently over 1500 system
> functions, this limits its usefullness. The patch standardizes
> everything on the way we do tables and indexes - the user ones are
> shown by default, and you add a capital "S" if you really want to
> see the system ones. So the patch would have \df show all your
> functions, \dD show all your domains, \doS shows the system
> operators, etc.

+1 :)

Cheers,
D
-- 
David Fetter david@xxxxxxxxxx http://fetter.org/
phone: +1 510 893 6100   mobile: +1 415 235 3778

Remember to vote!

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[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