6

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.

4 Answers 4

2

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: http://library.linode.com/search?query=postgresql (choose your relevant OS/version)

2

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

Hope this will help you:

http://www.postgresql.org/docs/8.4/interactive/index.html

1
1

This may help: https://help.ubuntu.com/community/PostgreSQL

0

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 :(

1
  • 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, 2010 at 22:09

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .