Hello all, WIth Postgres Is there a way to check if a schema exists using exposed? I can find out us...

# exposed

[Rodrigo Silva]

Hello all,
WIth Postgres
Is there a way to check if a schema exists using exposed?
I can find out using psql with the command
SELECT schema_name FROM information_schema.schemata WHERE schema_name = 'schema';

[neetkee]

you can use exec method https://github.com/JetBrains/Exposed/wiki/FAQ#q-is-it-possible-to-use-native-sql--sql-as-a-string

[spand]

https://github.com/JetBrains/Exposed/blob/5fd50f1f9da243f1d4bcfc01b60c0af8d5240155/exposed-core/src/main/kotlin/org/jetbrains/exposed/sql/Queries.kt#L236