pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
listing installed modules
2+ messages / 2 participants
[nested] [flat]

* listing installed modules
@ 2011-12-27 14:55  Daniel Vázquez <daniel2d2art@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Daniel Vázquez @ 2011-12-27 14:55 UTC (permalink / raw)
  To: pgsql-admin

How to get a list of contrib module installed extensions on Postgresql
8.4??

I see \dx command for 9.1 but not works on 8.4

thx!

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: listing installed modules
@ 2011-12-27 15:29  Guillaume Lelarge <guillaume@lelarge.info>
  parent: Daniel Vázquez <daniel2d2art@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Guillaume Lelarge @ 2011-12-27 15:29 UTC (permalink / raw)
  To: Daniel Vázquez <daniel2d2art@gmail.com>; +Cc: pgsql-admin

On Tue, 2011-12-27 at 15:55 +0100, Daniel Vázquez wrote:
> How to get a list of contrib module installed extensions on Postgresql
> 8.4??
> 

If you mean installed on the OS, it's impossible from the SQL command
line. If you mean installed on your database, it's difficult to know.
You need to check if a specific function / type / operator / whatever
that this extension provides is available. It's difficult and error
prone.

That's why we now have the extensions system. Now as "in 9.1".

> I see \dx command for 9.1 but not works on 8.4
> 

Yes. That's because extensions are a new PostgreSQL object since the 9.1
release.


-- 
Guillaume
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com
  PostgreSQL Sessions #3: http://www.postgresql-sessions.org




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2011-12-27 15:29 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-12-27 14:55 listing installed modules Daniel Vázquez <daniel2d2art@gmail.com>
2011-12-27 15:29 ` Guillaume Lelarge <guillaume@lelarge.info>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox