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

7 votes300 views5 answers
Oracle alter table
SQL
6 votes288 views3 answers
Error Code: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mydb.term.year' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
1 vote252 views1 answer
Minus vs intersect in sql
SQL
1 vote266 views3 answers
Postgresql connect to database
SQL
1 vote282 views3 answers
Drop unique key constraint in sql server
SQL
0 vote295 views1 answer
Sql filter rows with condition
SQL
21 votes288 views6 answers
Change column in mysql
SQL
0 vote288 views1 answer
Automated psql csv export script on windows
SQL
52 votes477 views6 answers
Rename column sql
SQL
0 vote309 views1 answer
Add super privilege mysql
SQL