PostgreSQL/Table/Create Table

Create a new table by specifying the table name, along with all column names and their types

   <source lang="sql">

postgres=# postgres=# -- Create a new table by specifying the table name, along with all column names and their types: postgres=# postgres=# CREATE TABLE weather ( postgres(# city varchar(80), postgres(# temp_lo int, -- low temperature postgres(# temp_hi int, -- high temperature postgres(# prcp real, -- precipitation postgres(# date date postgres(# ); CREATE TABLE postgres=# postgres=# postgres=# drop table weather; DROP TABLE postgres=#

      </source>
   
  

Creating the books table

   <source lang="sql">

postgres=# -- Creating the books table postgres=# postgres=# CREATE TABLE books ( postgres(# id integer UNIQUE, postgres(# title text NOT NULL, postgres(# author_id integer, postgres(# subject_id integer, postgres(# CONSTRAINT books_id_pkey PRIMARY KEY (id)); NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "books_id_pkey" for table "books" CREATE TABLE postgres=# postgres=# \d books;

      Table "public.books"
  Column   |  Type   | Modifiers

---

+---------+-----------

id         | integer | not null
title      | text    | not null
author_id  | integer |
subject_id | integer |

Indexes:

   "books_id_pkey" PRIMARY KEY, btree (id)

postgres=# postgres=# postgres=# drop table books; DROP TABLE postgres=#

      </source>