Postgres 12

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE t (
  id int,
  geom geometry(point) NOT NULL DEFAULT 'POINT EMPTY'
);

CREATE TABLE


INSERT INTO t (id) VALUES (1),(2);

INSERT 0 2


SELECT * FROM t; 


id
geom


1
0101000000000000000000F87F000000000000F87F

2
0101000000000000000000F87F000000000000F87F



SELECT 2


SELECT 
  'POINT EMPTY'::geometry,
  'POLYGON EMPTY'::geometry,
  'LINESTRING EMPTY'::geometry,
  'MULTILINESTRING EMPTY'::geometry,
  'MULTIPOLYGON EMPTY'::geometry,
  'MULTIPOINT EMPTY'::geometry,
  'POLYHEDRALSURFACE EMPTY'::geometry,
  'TRIANGLE EMPTY'::geometry,
  'TIN EMPTY'::geometry,
  'GEOMETRYCOLLECTION EMPTY'::geometry;


geometry
geometry
geometry
geometry
geometry
geometry
geometry
geometry
geometry
geometry


0101000000000000000000F87F000000000000F87F
010300000000000000
010200000000000000
010500000000000000
010600000000000000
010400000000000000
010F00000000000000
011100000000000000
011000000000000000
010700000000000000



SELECT 1

id	geom
1	0101000000000000000000F87F000000000000F87F
2	0101000000000000000000F87F000000000000F87F