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
\dx
>>sql code method
select * FROM pg_extension;
>>view available extensions
select * FROM pg_available_extensions
This is only a preview. Your comment has not yet been posted.
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.
Posted by: |