I hate paying for software, so when I do, I make sure there isn't anything free that can do the job. In the case of PostgreSQL, a lot of free software exists that claim they are GUI but for a simple task of creating a table, you need to know the Syntax of SQL. My favorite which is great for MySQL is HeidiSQL has an experimental version for Postgres. The reason why they call is "experimental" is if you specify the name of a database (or at least for me), it will not even load that database for you to create/edit/remove columns or even entries. After a little more searching, the one that I've found works the best is an application called DataGrip from JetBrains.
DataGrip is awesome. It works with almost every database structure you can think of including PostgreSQL. It allows you to easily create databases, tables, columns, and entries without knowing any SQL at all. It is very user-friendly and is compatible with Windows, OS X, and Linux. You can even create a table and get the creation SQL code for it. With this application, you will easily be able to:
- read and write data to database
- design forms field with different datatype (assuming you are talking about columns)
- reading and inserting images into a database. (You can turn the image into data through something like base64 format)
I don't really know what you mean by drop down menus but there are those in the application itself. It's free for students and open source projects - see their license for more information regarding that.
DataGrip is a database IDE from JetBrains that is tailored to suit
specific needs of professional SQL developers and DBAs.
Intelligent query console Allows you to execute queries in different
modes and provides local history that keeps track of all your activity
and protects you from losing your work.
Efficient schema navigation Lets you jump to any table, view, or
procedure by its name via corresponding action, or directly from its
usages in the SQL code.
Explain plan Gives you an extended insight into how your queries work
and into database engine behavior so you can make your queries more
Supported database servers / schemes: MySQL, SQL Server, Oracle
Database, PostgreSQL, SQLite, HyperSQL, Sybase, IBM DB2, H2