SEQUEL for PostgreSQL is a professional DB administration and management tool, with extremely intuitive and feature rich GUI that makes it the best assistant tool for developers and admins. Database Management made easy Modern, native, and friendly GUI tool for relational databases: MySQL, PostgreSQL, SQLite & more Download for Mac Upgrade Now for $49. Requires macOS 10.11. PostgreSQL Tools pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world. PgAdmin may be used on Linux, Unix, Mac OS X and Windows to manage PostgreSQL 9.2 and above. Psequel is a PostgreSQL GUI tool for macOS. I am new to PostgreSQL database I just want to know is there any GUI Tool for PostgreSQL just like SQLYog for MySql.
Currently, I am using standalone GUI tool DbSchema to design my database schema.
I like it because it can
- Generate SQL code.
- Have graphing view on my entire database schema.
(source: google.com)
However, I realize the SQL code generate by DbSchema is not being recognized by PostgreSQL.
I get the error :
Is there any alternative 'just work' free tool that I can work with PostgreSQL, by providing above 2 features?
Glorfindelclosed as off-topic by Artjom B., legoscia, Bryan Musial, Fred Larson, JasonMArcherJan 10 '15 at 18:59
This question appears to be off-topic. The users who voted to close gave this specific reason:
- 'Questions asking us to recommend or find a book, tool, software library, tutorial or other off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it.' – Artjom B., legoscia, Bryan Musial, Fred Larson, JasonMArcher
2 Answers
Best Gui Tool For Postgres On Mac
I like the VisualUML/DBA kit. Its not free but it sure is nice. It'll do what you are asking for and it'll generate the DB (with your favorite DBMS) create/drop script for you.
monksymonksyDepending on what platform you are working you have some options:
Postgresql Mac Os
- OpenOffice.Org(!)