Say I have created some user-defined types in the DB,
i.e. CREATE TYPE abc ...
Is it then possible to determine if the user-defined type exists or not? Perhaps, using any of the postgres information tables?
The main reason for this is since PostgreSQL does not seem to support CREATE OR REPLACE TYPE ...
, and if a certain type gets created more than once, I want to be able to drop the existing one first, then re-load the new one.
I add here the complete solution for creating types in a simple script, without the need of creating a function just for this purpose.
--create types DO $$ BEGIN IF NOT EXISTS (SELECT 1 FROM pg_type WHERE typname = 'my_type') THEN CREATE TYPE my_type AS ( --my fields here... ); END IF; --more types here... END$$;
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With