tag:blogger.com,1999:blog-8607839690848429399.post481755545884743856..comments2013-03-14T10:09:53.415-07:00Comments on BioBlog5000: Learning pgKill Facehttp://www.blogger.com/profile/00783270313087456038noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-8607839690848429399.post-65745078982746470792011-08-09T08:16:42.316-07:002011-08-09T08:16:42.316-07:00Rather:
SHOW DATABASES is:
SELECT datname FROM ...Rather:<br /><br />SHOW DATABASES is:<br /><br /> SELECT datname FROM pg_database;<br /><br /><br />and SHOW TABLES (in a database) is:<br /><br />SELECT<br /> tablename<br />FROM<br /> pg_tables<br />WHERE<br /> schemaname = 'public'<br />;Kill Facehttps://www.blogger.com/profile/00783270313087456038noreply@blogger.com