Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

What tools are used to query against a PostgreSQL database?

What tools are used to query against a PostgreSQL database?

What tools are used to query against a PostgreSQL database?

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?

RE: What tools are used to query against a PostgreSQL database?

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..."

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close