PDshell16逆向PostgreSQL 工程显示字段comment备注

本文主要是介绍PDshell16逆向PostgreSQL 工程显示字段comment备注，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

现状：当刚逆向成功的表结构是没有原来表结构中的，comment备注如下

然后pd逆向工程的sql已经返回了这个备注的含义

解决方案：

1、设置显示注释列
tools——Display Preferences…如下



勾选-按照下面得方式勾选这三个

复制这里的VBS脚本，打开菜单Tools>Execute Commands>Edit/Run Script… 或者用快捷键 Ctrl+Shift+X

    Option   Explicit     ValidationMode   =   True     InteractiveMode   =   im_Batch  Dim blankStr  blankStr   =   Space(1)  Dim   mdl   '   the   current   model    '   get   the   current   active   model     Set   mdl   =   ActiveModel     If   (mdl   Is   Nothing)   Then     MsgBox   "There   is   no   current   Model "     ElseIf   Not   mdl.IsKindOf(PdPDM.cls_Model)   Then     MsgBox   "The   current   model   is   not   an   Physical   Data   model. "     Else     ProcessFolder   mdl     End   If    Private   sub   ProcessFolder(folder)     On Error Resume Next    Dim   Tab   'running     table     for   each   Tab   in   folder.tables     if   not   tab.isShortcut   then     tab.name   =   tab.comment    Dim   col   '   running   column     for   each   col   in   tab.columns     if col.comment = "" or replace(col.comment," ", "")="" Then  col.name = blankStr  blankStr = blankStr & Space(1)  else    col.name = col.comment     end if    next     end   if     next    Dim   view   'running   view     for   each   view   in   folder.Views     if   not   view.isShortcut   then     view.name   =   view.comment     end   if     next    '   go   into   the   sub-packages     Dim   f   '   running   folder     For   Each   f   In   folder.Packages     if   not   f.IsShortcut   then     ProcessFolder   f     end   if     Next     end   sub    

如下：

显示出来了

这篇关于PDshell16逆向PostgreSQL 工程显示字段comment备注的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---