Postgresql create query

CREATE TABLE COMPANY(
   ID INT PRIMARY KEY     NOT NULL,
   NAME           TEXT    NOT NULL,
   AGE            INT     NOT NULL,
   ADDRESS        CHAR(50),
   SALARY         REAL,
   JOIN_DATE	  DATE
);

INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY,JOIN_DATE) VALUES (1, 'Paul', 32, 'California', 20000.00,'2001-07-13');
INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,JOIN_DATE) VALUES (2, 'Allen', 25, 'Texas', '2007-12-13');
INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY,JOIN_DATE) VALUES (3, 'Teddy', 23, 'Norway', 20000.00, DEFAULT );
INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY,JOIN_DATE) VALUES (4, 'Mark', 25, 'Rich-Mond ', 65000.00, '2007-12-13' ), (5, 'David', 27, 'Texas', 85000.00, '2007-12-13');

Source: tutorialspoint.com

Similar codes

1 vote216 views1 answer
Mysql update inner
SQL
13 votes202 views3 answers
Insert mysql ifile nto database
SQL
17 votes215 views4 answers
Postgres list users
SQL
17 votes194 views6 answers
Mysql import sql file
SQL
13 votes216 views4 answers
What is sql
SQL
24 votes191 views5 answers
Sql server insert into select
SQL
11 votes190 views3 answers
Sqlite3 create table from another table
SQL
3 votes208 views1 answer
APEX elapsed time
SQL
0 vote188 views1 answer
Sqlserver now
SQL
0 vote204 views1 answer
Postgres regex word boundary
SQL