support for timestamptz

[jeffbum]

when converting from postgres --> dbml, timestamptz is not supported. Can switch in sql documentation to timestamp, just complicates it further than needed to be. Output of timestamp in dbml is fine as well.

[jeffbum]

found, if I change timestamptz to 'timestamp with time zone', it generates just as well. It's a little work on my end, but should not be too difficult. would still like to see timestamptz conversion just the same.

[nvquanghuy]

Hi @jeffbum, sorry I missed this. I don't quite understand why timestampz is not supported when converting from postgres -> dbml. Can you share reproduction steps pls?

[incompletude]

+1

CREATE TABLE "public"."payment" (
    "id_payment" int8 NOT NULL DEFAULT nextval('payment_id_payment_seq'::regclass),
    "created_at" timestamptz NOT NULL,
    PRIMARY KEY ("id_payment")
);

It is quite simple, this will break the cli while it is completely fine PostgreSQL script.

[csangonzo]

+1

[khoahuynhdev]

+1