Schema and database has to be represented in application too.
Feature
Create a class representing database and schema. Schema's owner to come from dbowner.txt file.
Both classes offer SQL entries for their creations.
NB!
There's no simple SQL expression to create database safely. It will have to be done either via PL/pgSQL expression or doing a query first (preferably the first).
Zejnilovic
commented
1 year ago
Background
Schema and database has to be represented in application too.
Feature
Create a class representing database and schema. Schema's owner to come from
dbowner.txtfile. Both classes offer SQL entries for their creations.NB! There's no simple SQL expression to create database safely. It will have to be done either via PL/pgSQL expression or doing a query first (preferably the first).