I know that SQL is an option, but I'm looking for an easier text-based interface for PostgreSQL. Something that's similar to what 'tig' is to 'git'. Does any one know something like this?
PostgreSQL comes with a command line client: psql
(<a href="http://www.postgresql.org/docs/6.4/static/app-psql.htm" rel="nofollow">http://www.postgresql.org/docs/6.4/static/app-psql.htm</a>)<p>If you're going to work with a relational database you need to learn SQL and how the relational model works. There's no shortcut that won't just leave you worse off in the long run. SQL was originally designed as an end-user friendly way to work with relational data.<p>For learning about relational database theory I recommend Chris Date's book "Database In Depth: Relational Theory For Practitioners." There are quite a few good books for learning SQL. For learning the PostgreSQL flavor of SQL the PostgreSQL docs are probably the best place to start.