funciona - crear tabla en postgreSQL

ejemplos de tipos de datos en postgresql

Question

No entiendo qué está mal con esta consulta? La herramienta de consulta no quiere crear una tabla en PostgreSQL.

CREATE TABLE article (
article_id bigint(20) NOT NULL auto_increment,
article_name varchar(20) NOT NULL,
article_desc text NOT NULL,
date_added datetime default NULL,
PRIMARY KEY (article_id)
);

Answer 1

Por favor intente esto:

CREATE TABLE article (
  article_id bigint(20) NOT NULL serial,
  article_name varchar(20) NOT NULL,
  article_desc text NOT NULL,
  date_added datetime default NULL,
  PRIMARY KEY (article_id)
);

Answer 2

Primero, el bigint(20) not null auto_increment no funcionará, simplemente use bigserial primary key . Entonces datetime es la timestamp de timestamp en PostgreSQL. Considerándolo todo:

CREATE TABLE article (
    article_id bigserial primary key,
    article_name varchar(20) NOT NULL,
    article_desc text NOT NULL,
    date_added timestamp default NULL
);

Answer 3

Reemplace bigint(20) not null auto_increment por bigserial not null y datetime por timestamp

Answer 4

-- Table: "user"

-- DROP TABLE "user";

CREATE TABLE "user"
(
  id bigserial NOT NULL,
  name text NOT NULL,
  email character varying(20) NOT NULL,
  password text NOT NULL,
  CONSTRAINT user_pkey PRIMARY KEY (id)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE "user"
  OWNER TO postgres;