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.
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. # 1
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. # 2
  • Page :
  • 1


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

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories