PostgreSQL – Introduction



PostgreSQL – Introduction

0 0


PostgreSQL-Introduction-Part-I

Introduction to PostgreSQL

On Github SUNY-Albany-CCI-LearningEncounters / PostgreSQL-Introduction-Part-I

PostgreSQL

Introduction

Created by Luis Ibanez

Introduction to PostgreSQL by Luis Ibanez is licensed under a Creative Commons by Attribution 4.0 License Apache 2.0 License

PostgreSQL

Database

www.postgresql.org

PostgreSQL

List Help

psql --help

List Databases

psql --list

Open Database

psql -U $username -d  $databasename

Example

psql -U ibanez -d grades

Ask for Help

\?

List Users and Roles

\du

List Databases

\l

List Tables

\dt

Data Definition

Language (DDL)

  • CREATE
  • DROP
  • ALTER

Data Manipulation

Language (DML)

  • INSERT
  • UPDATE
  • DELETE

THE END