[ADMIN] listing installed modules

[Daniel Vázquez]

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!

[Guillaume Lelarge]

Post by Daniel Vázquez
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".

Post by Daniel Vázquez
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