How to list extensions in PostgreSQL

27 December,2018 by Rambler

Question: I've added an extension on PostgreSQL  during the creation of a DBLink extension for cross database queries. The command I've executed is CREATE EXTENSION dblink.   

How can I list all the extensions within the PostgreSQL db , to confirm the extension is registered?


Answer:    To view information on PostgreSQL extensions you can either use the psql command or you can use some sql code 

>>psql method


>>sql code method 

select * FROM pg_extension;

>>view available extensions

select * FROM pg_available_extensions


Author: Rambler (


Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment on How to list extensions in PostgreSQL