nudepig

postgres远程配置：pg_hba.conf文件 底部加入host all all 0.0.0.0/0 md5postgresql.conf文件 #listen_addresses=’localhost’，修改成listen_addresses=’*’查看状态sudo /etc/init.d/postgresql status启动sudo /etc/init.d/postgresql start停止sudo /etc/init.d/postgresql stop重启sudo

select(select relname ||’–’||(select description from pg_description where objoid = oid and objsubid = 0) from pg_class where oid=a.attrelid) as 表名,a.attname as 列名,format_type(a.atttypid,a.atttypmod) as 类型,(case when atttypmod-4>0 then atttypmod-4 e

psql 进入命令行\h：查看SQL命令的解释，比如\h select。\?：查看psql命令列表。\l：列出所有数据库。\c [database_name]：连接其他数据库。\d：列出当前数据库的所有表格。\d [table_name]：列出某一张表格的结构。\du：列出所有用户。\e：打开文本编辑器。\conninfo：列出当前数据库和连接的信息。drop database “odoo-test”; 删除数据库drop user xxx; 删除用户General\copyri