postgres create extension if not exists
CREATE EXTENSION [ IF NOT EXISTS ] extension_name
[ WITH ] [ SCHEMA schema_name ]
[ VERSION version ]
[ FROM old_version ]postgres create extension if not exists
CREATE EXTENSION [ IF NOT EXISTS ] extension_name
[ WITH ] [ SCHEMA schema_name ]
[ VERSION version ]
[ FROM old_version ]postgresql CREATE EXTENSION pgcrypto
##############
# PostgreSQL #
##############
#-> Listando extensões instaladas e suas versões
select * from pg_available_extensions where installed_version is not NULL
#-> Listando extensões avaliadas e suas versões
select * from pg_available_extensions where installed_version is NULL
#-> Instalando extensão para suporte a criptografia
CREATE EXTENSION pgcrypto;Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
