[Postgres] Create a Postgres Table

Learn how to create a table using the most widely-used data types (serial, varchar, integer, float, boolean, and date), and the most necessary constraints (NOT NULL and primary key).

CREATE TABLE directors (

  id SERIAL PRIMARY KEY,

  name VARCHAR() UNIQUE NOT NULL

);

CREATE TABLE movies (

  id SERIAL PRIMARY KEY,

  title VARCHAR() NOT NULL,

  release_date DATE,

  count_stars INTEGER,

  director_id INTEGER

);

巴特西

[Postgres] Create a Postgres Table

最新文章

热门文章