c_table.sql

The following command file creates a database named restock and then creates a custom table named sports in that database:

CREATE DATABASE restock;

CREATE TABLE sports
   (
   catalog_no          SERIAL UNIQUE,
   stock_no            SMALLINT,
   mfg_code            CHAR(5),
   mfg_name            CHAR(20),
   phone               CHAR(18),
   descript            VARCHAR(255)
   );