Answers for "how to create table postgresql"

SQL
12

create table in postgresql

-- Example table
 CREATE TABLE accounts (
	user_id serial PRIMARY KEY,
	username VARCHAR ( 50 ) UNIQUE NOT NULL,
	password VARCHAR ( 50 ) NOT NULL,
	email VARCHAR ( 255 ) UNIQUE NOT NULL,
	created_on TIMESTAMP NOT NULL,
        last_login TIMESTAMP 
);
Posted by: Guest on December-12-2020
0

create table database in psql

virtual_pets=# CREATE TABLE communities (id SERIAL PRIMARY KEY, name varchar, description varchar);
CREATE TABLE
Posted by: Guest on August-11-2021

Code answers related to "how to create table postgresql"

Code answers related to "SQL"

Browse Popular Code Answers by Language