Ask Ubuntu is a question and answer site for Ubuntu users and developers. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Are there any how-to's or tutorials about postgresql 8.4 fro doing following things:

  • Logging in to postgresql
  • creating database
  • getting into database environment
  • adding or altering the tables

Sorry for asking this question here. I googled for 3 hrs online without being able to clarify any of my issues. I also tries the Ubuntu community wiki, it wasn't that much helpful about using a already created database.

share|improve this question
up vote 2 down vote accepted

I was in your position too, and I agree, it's hard to find anything at a basic enough level. Postgresql is a bit more complicated than MySQL, but it's not impossible to figure out.

The greatest help I've found was this article on Linode Library: (choose your relevant OS/version)

share|improve this answer

You can use pgadmin, a gui client for PostgreSQL for all these purpose. It is in the software center.

Hope this will help you:

share|improve this answer
Here is the pgadmin documentation : – aneeshep Nov 5 '10 at 5:00

I'm in a very similar spot... I have a little bit of MySQL knowledge, and having a bit of trouble figuring out the equivalents in PostgreSQL.

I don't know if it helps any, but one thing that took me a bit to get my head around (still working on it, really) is the concept of 'roles' in postgres vs. 'users' in mysql. Ch. 20 in the manual (linked above) talks a bit about roles.

Other than that... I'm listening along with ya. On my Macbook I installed PostgreSQL 9.0.1 lickety-split using a one-click installer from EnterpriseDB and fired up pgAdmin no problemo. My first attempt at following the chicken-scratch in the Ubuntu Community Wiki ended in failure, as I think I followed the portion for the wrong version of Ubuntu/Postgres :(

share|improve this answer
The PostgreSQL portion of this page listed in the Wiki seems to be close enough (10.04/Lucid & 10.10/Maveric haven't yet upgraded past pg 8.4) to get things rolling. – memilanuk Nov 6 '10 at 22:09

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.