Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
Add a reply View Replies (2)

Resolved Attach script to creation of table object

  1. Andrew Lazarus
    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.
  1. schema_editor
Comment
There are no comments made yet.
Responses (2)
Andrew Lazarus
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
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.