What tools are used to query against a PostgreSQL database?

[Apollo6]

I am new to this type of database. My experience is based from working with an Oracle database sitting on a UNIX environment. I was able to sign into a utility called SQL-Plus from the UNIX prompt. This would bring up an command line environment which I could write basic SQL statements against the database.

Currently, this PostgreSQL database is on a Linux platform. Is there any type of utility that I can use to give me the same functionality that the above mentioned SQL-Plus tool gave me?

 

[rycamor]

The console-based PostgreSQL tool is called 'psql'. You just call it from your command-line environment in Linux: 1. you must be the same username as the database owner (or you will need extra parameters) 2. enter 'psql databasename', and you will be logged into the PostgreSQL console, where you can run queries agains the database.

There are many other tools to access PostgreSQL, depending on the desktop environment you are using, or the programming environments you are using. Spend some time at

http://techdocs.postgresql.org/,

for more info. -------------------------------------------

"Now, this might cause some discomfort..."
(

http://www.wired.com/news/politics/0,1283,51274,00.html)