Red icon indicating copy to clipboard operation
Red copied to clipboard

Some method to enable PostgreSQL extensions?

Open kawaii opened this issue 4 years ago • 1 comments

It's nice that Red can create tables for me if they don't already exist, but would it be possible to have some way to enable extensions when they are needed? Or perhaps this is already possible? :)

Example, allows for use of the 'uuid' column type;

CREATE EXTENSION IF NOT EXISTS "uuid-ossp";

kawaii avatar Apr 29 '21 21:04 kawaii

That's a good idea! But for now, if needed you can do something like this:

red-do {
    .execute: 'CREATE EXTENSION IF NOT EXISTS "uuid-ossp"'
}

FCO avatar May 04 '21 13:05 FCO