0

I have been working with Microsoft SQL Server since 6.5 along with other database like Oracle, MySQL and SQLite. I equally appreciate or hate all these DBMS for some point or the other.

On our forthcoming project, we are considering Postgres in the back-end. I have already started playing with it, pretty interesting for me.

I have always heard good comments on Postgres database, but I don't like the admin studio at all. While creating new a table, I hate the way of creating columns on pgAdmin by having to click add button again and again.

Are there any "Studios" for Postgres database that provide

  1. more organized table creation process (spreadsheet like)
  2. graphical view designer
Improve this question
1
  • 1
    Just a side note: tables for a production system should not be created by GUI tool. Create the approriate SQL scripts, store them in a version control system and run them against the database to create your tables. Commented Feb 1, 2011 at 17:31

3 Answers 3

Reset to default
3

What's wrong with plain SQL? Writing plain SQL goes much faster than click-wait-click-wait-type-click-wait-ok-wait. You could use any tool for this, pgAdmin as well.

Open Office Base can also connect with PostgreSQL, works like MS Access. And talking about MS Access, MS Access can also connect to PostgreSQL to create tables, views, etc.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

2

See this official list of Administration/Development tools.

EMS SQL Manager seems to be a good option.

Improve this answer

Comments

-1

for the graphical view of SQL queries maybe SQLeo can Help

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.