SyntaxFix

[postgresql] create table in postgreSQL

First the bigint(20) not null auto_increment will not work, simply use bigserial primary key. Then datetime is timestamp in PostgreSQL. All in all:

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

Examples related to postgresql

• Subtracting 1 day from a timestamp date • pgadmin4 : postgresql application server could not be contacted. • Psql could not connect to server: No such file or directory, 5432 error? • How to persist data in a dockerized postgres database using volumes • input file appears to be a text format dump. Please use psql • Postgres: check if array field contains value? • Add timestamp column with default NOW() for new rows only • Can't connect to Postgresql on port 5432 • How to insert current datetime in postgresql insert query • Connecting to Postgresql in a docker container from outside

Examples related to create-table

• Field 'id' doesn't have a default value? • MySQL: Error Code: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB • Create hive table using "as select" or "like" and also specify delimiter • #1064 -You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version • C# - Create SQL Server table programmatically • How do I create a table based on another table • Creating new table with SELECT INTO in SQL • create table in postgreSQL • PostgreSQL Error: Relation already exists • Mysql: Setup the format of DATETIME to 'DD-MM-YYYY HH:MM:SS' when creating a table