1. Andrew Lazarus
  2. Valentina Studio
  3. Thursday, October 28 2021, 07:42 PM
  4.  Subscribe via 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.
Comment
There are no comments made yet.
Andrew Lazarus Accepted Answer
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.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 1
Sergey Pashkov Accepted Answer
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?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 2
  • Page :
  • 1


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