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

3 votes122 views3 answers
Update con select postgresql
SQL
0 vote111 views2 answers
Sql server set default value equal to auto increment
SQL
0 vote123 views2 answers
How to see table associated with a schema in sql
SQL
39 votes169 views4 answers
Select duplicates in sql
SQL
0 vote107 views2 answers
Identity syntax in sql
SQL
1 vote102 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL
0 vote101 views1 answer
Monthly Birthday SQL Query
SQL
0 vote231 views1 answer
Oracle convert int to date
SQL
1 vote107 views1 answer
Select not matching data from two tables
SQL
2 votes101 views1 answer
Delete all value query
SQL