postgres check schema exists code example

Example: check schema exists postgresql

SELECT schema_name FROM information_schema.schemata WHERE schema_name = 'name';