Results 1 to 3 of 3

Thread: newbie question

  1. #1
    Join Date
    Jul 2009

    Unanswered: newbie question


    I am learning to use a database. I got postgresql 8.3 installed om my ubuntu and was wondering what is the difference between pgadmin111 and using it from command line. Is there a book or a website where i can learn how to use this.

  2. #2
    Join Date
    Nov 2006
    pgAdmin is for windows fans, you can click here to do many things with psql you have to use keyboard .
    Did you read manual for pgadmin at
    pgAdmin: PostgreSQL administration and management tools
    and postgresql manual at
    PostgreSQL: Documentation: Manuals: PostgreSQL 8.3: PostgreSQL 8.3.7 Documentation

  3. #3
    Join Date
    Jun 2004
    Arizona, USA
    pgAdmin is a GUI (graphical user interface) for PostgreSQL development. If you're familiar with SQL Server, pgAdmin is the equivalent of Enterprise Manager.

    psql is a text oriented interface to Pg. It is also the tool of choice for batch scripting, as you can pass SQL text files to it using the command line.

    Some commands are available via standalone apps using the command line: Backup, Restore, Createdb, etc.

    Review the documentation - it's all 'in there.'

    PostgreSQL, 2nd edition, by Douglas & Douglas, is a well written reference, as well.
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts