Skip to content
On this page

PG Quick Start

Installation

  1. I'll not record this part of things. Because, there're such many different ways to do that in different Platforms. But I recommand you to take a look at the original and hack way.

Tricks

  1. The psql program has a number of internal commands which's useful when you are learning. Like, /h to show how to create/update objects, and ``?` to show how many commands to do admin quick selecting.

  2. Some common and often used commands
    a. \q --> quit
    b. \d --> describe
    c. \c --> connect/use database
    d. `` -->

Privileges