1. Andrew Lazarus
  2. Valentina Studio
  3. Четверг, Октябрь 28 2021, 07:42 PM
  4.  Подписаться через email
When I forward engineer from a diagram, sometimes there is SQL I want to add to the script. For instance,

GRANT
and

REVOKE
,

INSERT
into constant tables,

CREATE EXTENSION
.

Is there any provision for this? Per object would be great, per database would be acceptable.
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Hello Andrew,

No, currently it is not possible.
So it's like some "initialization" process. It looks like we can add a few types of scripts - for example, to place before and after the object definition, right?
Комментарий
There are no comments made yet.
Andrew Lazarus Ответ принят
Exactly. For example, I could "CREATE EXTENSION gist" near the top of the SQL file for DB creation, and then add the GIST-based indexes for the tables that use them.
Комментарий
There are no comments made yet.
  • Страница :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.