Toggle Submenu
  1. Forums
  2. Recent
  3. カテゴリ
  4. タグ
  5. ユーザ
返信を追加 返信を表示 (2)

解決済み Attach script to creation of table object

  1. Andrew Lazarus
    Andrew Lazarus
  2. Valentina Studio
  3. 木, 10月 28 2021, 07:42 PM
  4.  メールで購読
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
コメント
There are no comments made yet.
返信 (2)
Andrew Lazarus
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. 一ヶ月以上前
  2. Valentina Studio
  3. この返信へのパーマリンク
Sergey Pashkov
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.
  1. 一ヶ月以上前
  2. Valentina Studio
  3. この返信へのパーマリンク
  • ページ :
  • 1


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