postgres=# create table basictest
postgres-#            ( testint4 domainint4
postgres(#            , testtext domaintext
postgres(#            , testvarchar domainvarchar
postgres(#            , testnumeric domainnumeric
postgres(#            );
CREATE TABLE
postgres=# 
postgres=# INSERT INTO basictest values ('88', 'haha', 'short', '123.12');
INSERT 0 1
postgres=# select * from basictest;
2025-01-01 23:09:25.190 CST [1116620] WARNING:  01000: (PGDuckDB/GetPostgresDuckDBType) Could not convert DuckDB type: "UnsupportedPostgresType (Oid=245756)" to Postgres type
2025-01-01 23:09:25.190 CST [1116620] LOCATION:  GetPostgresDuckDBType, pgduckdb_types.cpp:978
2025-01-01 23:09:25.191 CST [1116620] WARNING:  01000: (PGDuckDB/CreatePlan) Cache lookup failed for type 0
2025-01-01 23:09:25.191 CST [1116620] LOCATION:  CreatePlan, pgduckdb_planner.cpp:77
WARNING:  (PGDuckDB/GetPostgresDuckDBType) Could not convert DuckDB type: "UnsupportedPostgresType (Oid=245756)" to Postgres type
WARNING:  (PGDuckDB/Create

create domain domainvarchar varchar(5);
create domain domainnumeric numeric(8,2);
create domain domainint4 int4;
create domain domaintext text;

-- Test tables using domains
create table basictest
           ( testint4 domainint4
           , testtext domaintext
           , testvarchar domainvarchar
           , testnumeric domainnumeric
           );

INSERT INTO basictest values ('88', 'haha', 'short'); 
select * from basictest;