Breaking News: Grepper is joining You.com. Read the official announcement!

details: pq: syntax error at or near "FOREIGN"

Restu Wahyu Saputra answered on September 7, 2022 Popularity 5/10 Helpfulness 1/10

answer details: pq: syntax error at or near "FOREIGN"

related details: pq: syntax error at or near "FOREIGN"

details: pq: syntax error at or near "FOREIGN"

Comment

CREATE TABLE IF NOT EXISTS "users" (
    "id" serial PRIMARY KEY,
    "name" varchar(25) UNIQUE NOT NULL,
    "password" varchar(255) NOT NULL,
    "role_id" int NOT NULL,
    "created_at" timestamp NOT NULL DEFAULT (now()),
    "updated_at"  timestamp NOT NULL DEFAULT (now()),
    "deleted_at" timestamp NULL
  );

ALTER TABLE "users" ADD FOREIGN KEY (role_id) REFERENCES "roles" ON DELETE CASCADE;

Popularity 5/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: near sql syntax-error

Link to this answer
Share Copy Link

Contributed on Sep 07 2022

Restu Wahyu Saputra

0 Answers Avg Quality 2/10

Closely Related Answers

details: pq: syntax error at or near "FOREIGN"

Comment

CREATE TABLE IF NOT EXISTS "users" (
    "id" serial PRIMARY KEY,
    "name" varchar(25) UNIQUE NOT NULL,
    "password" varchar(255) NOT NULL,
    "role_id" int NOT NULL,
    "created_at" timestamp NOT NULL DEFAULT (now()),
    "updated_at"  timestamp NOT NULL DEFAULT (now()),
    "deleted_at" timestamp NULL
  );

ALTER TABLE "users" ADD FOREIGN KEY (role_id) REFERENCES "roles" ON DELETE CASCADE;

Popularity 5/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: near syntax-error sql

Link to this answer
Share Copy Link

Contributed on Sep 07 2022

Restu Wahyu Saputra

0 Answers Avg Quality 2/10

details: pq: syntax error at or near "FOREIGN"

Contents

More Related Answers

details: pq: syntax error at or near "FOREIGN"

Closely Related Answers

details: pq: syntax error at or near "FOREIGN"

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.