擅长:python、mysql、java
<p>解决方案中缺少的是读取和解析从<code>psql</code>获得的信息:</p>
<pre><code>def get_database_info(host, user):
records, _ = subprocess.Popen(['psql','-lA','-F\x02','-R\x01','-h',host,'-U',user ],stdout=subprocess.PIPE).communicate()
records = records.split('\x01')
header = records[1].split('\x02')
return [dict(zip(header,line.split('\x02'))) for line in records[2:-1]]
</code></pre>