pgAdmin

1.如果postgresql安装的是9.0或以上版本，pgAdmin必须安装1.12版本或以上，否则报错如下：

   ERROR: column "datconfig" does not exist LINE 1: ...b.dattablespace AS spcoid, spcname, datallowconn, datconfig, .... 
    I click ok and then it shows another error: Column not found in pgSet: rolconfig .  And after I click ok again it connects to the server but it doesn't show the databases.. 

2.安装好pgAdmin,打开启动

引用该文章 http://blog.sina.com.cn/s/blog_6d2bb4da0100xh6n.html

  

3.调用plugins->psql console，命令行工具