Ask HN: Text-based interface for PostgreSQL?

Re:Ask HN: Text-based interface for PostgreSQL? by tinyProton on Wednesday September 11, 2013 @09:50PM (#6371529)

Thanks for your reply, but that's exactley what I don't want to do. I know about psql and I know how to write SQL statements, but what I'm looking for is a text-based interface that let me perform tasks (similar to what you can do with phpmyadmin) without writing SQL statements.

[ Parent | on HN ]

Re:Ask HN: Text-based interface for PostgreSQL? by gregjor on Friday September 13, 2013 @07:20AM (#6379739)

I'm having a hard time imagining an easier text-based interface to an RDBMS than the command line client. For things I do frequently -- backup a database, dump just the schema, export a view as CSV -- I write shell scripts around psql or the mysql CLI. You can use command-line parameters and hide the psql options and commands that you don't want to look up over and over. Obviously you could do the same thing with other tools if you don't like sh/bash scripting.

[ Parent | on HN ]