Import from PostgreSQL does not support auto-generated UUIDs as PK?

Ask the Community
1

I’m trying to use the import from PostgreSQL feature, but it’s failing on auto-generated UUID column definition for primary key

CREATE TABLE public.accounts (
    id uuid DEFAULT public.gen_random_uuid() NOT NULL
)

The error shown in the import dialog is:

Expected ")", ",", "CHECK", "CONSTRAINT", "DEFAULT", "GENERATED", "NOT", "NULL", "PRIMARY", "REFERENCES", "UNIQUE", ['.a-z0-9_+\-], or space but "(" found.

2

It would be also nice that to add support for type timestamptz while importing.