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'))