support uuid type in console

[0x777]

While UUID type is natively supported in Postgres, pgcrypto extension has to be enabled to add a default value.

Without default value:

CREATE TABLE article ( 
  id UUID PRIMARY KEY,
  title TEXT NOT NULL
)

With default value:

CREATE EXTENSION IF NOT EXISTS pgcrypto;
CREATE TABLE article (
  id UUID DEFAULT gen_random_uuid() PRIMARY KEY,
  title TEXT NOT NULL
);

[shahidhk]

via michael on intercom.