CS 257: Software Design

Common commands

Contents

Unix

psql basics

Launch psql with your postgresql user name:

psql -U user-name database-name

The psql prompt:

The rest of these are "psql directives"—stuff you type at the psql prompt.

build database from scratch

clear or remove database

copy database to a different computer