O'Reilly logo

Discovering SQL: A Hands-On Guide for Beginners by Alex Kriegel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

POSTGRESQL 9.0

PostgreSQL ships with a rather slick pgAdmin management console that facilitates most of the administrative tasks conducted both through the visual point-anA-click interface and the SQL queries window. There is also a commanA-line SQL Shell interface that until recently was the only native interface to the PostgreSQL RDBMS.

Installing with pgAdmin III

  1. Launch pgAdmin from Programs images PostgreSQL 9.0 images pgAdmin III. The initial screen is shown in Figure A-24.

    images

    FIGURE A-24

  2. Connect to the postgres server by selecting the server node and selecting the Connect menu option from the right-click pop-up menu, as shown in Figure A-25.

    images

    FIGURE A-25

  3. In the next step, bring up the SQL query console by clicking the SQL icon on the pgAdmin toolbar, as shown in Figure A-26.

    images

    FIGURE A-26

  4. Load the CREATE DATABASE script by clicking the Open File icon on the toolbar and navigating to the DiscoveringSQL.PostgreSQL.CreateDB.sql file, or simply type the statement shown in Figure A-27. Click the Execute ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required