Export default timezone is incorrect
Database management in a single PHP file
Brought to you by:
jakubvrana
Table:
CREATE TABLE public.test(
id int,
created_at timestamp DEFAULT timezone('UTC'::text, now())
);
export via Adminer contain error:
-- Adminer 4.7.5 PostgreSQL dump
DROP TABLE IF EXISTS "test";
CREATE TABLE "public"."test" (
"id" integer,
"created_at" timestamp DEFAULT timezone('UTC'))
) WITH (oids = false);
TRUNCATE "test";
-- 2020-01-28 12:10:30.620718+00
The same bug while edit table structure: default value is
timezone('UTC'))