postsql獲取表字段信息SQL

select * from pg_class where relname='sys_application';select attname from pg_catalog.pg_attribute where attnum>0 and attrelid in(select oid from pg_class where relname='sys_application');

修改postsql庫中布爾型字段的值的SQL

update sys_template_form set enabled2=true where enabled='1'; update sys_template_form set enabled2=false where enabled='0';update sys_template_flow set enabled2=true where enabled=1; update sys_template_flow set enabled2=false where enabled=0; update sys_template_flow set deleted2=true where deleted=1; update sys_template_flow set deleted2=false where deleted=0;

修改postsql庫中字段名稱的SQL

alter table sys_application rename "OID" to oid; DbTable dtt = db.getTableSchema(tab); for (int j = 0; j < dtt.Fields.Count; j++) {string fd = dtt.Fields[j].Name;if (fd.ToLower() != fd){db.ExecuteNonQuery("alter table " + tab + " rename \"" + fd + "\" to " + fd.ToLower());} }

—the—end—

總結

以上是生活随笔為你收集整理的postsql获取表字段信息SQL的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。