Postgresql: Check if Schema Exists?

The following query will tell you whether a schema exists.

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