INSERT INTO pg_catalog.pg_type SELECT 'pickle' AS typname, typnamespace, typowner, typlen, typbyval, typtype, typisdefined, typdelim, typrelid, typelem, typinput, typoutput, typreceive, typsend, typanalyze, typalign, typstorage, typnotnull, typbasetype, typtypmod, typndims, typdefaultbin, typdefault FROM pg_catalog.pg_type WHERE typname = 'text'; CREATE TABLE employee ( employee SERIAL PRIMARY KEY, fullname TEXT, photo PICKLE );