6/17/2023 0 Comments Pgadmin 4 tutorialThe features of PostgreSQL are as follows: It originates in the year 1986 and has been into active development for more than 30 years. PostgreSQL is an object-relational database system which extends and uses the SQL language. What is PostgreSQL? – PostgreSQL Tutorial The TCL (Transaction Control Language) commands deal with the transaction of the database.Example: BEGIN, COMMIT, ROLLBACK.Īpart from the commands, the following topics will be covered in this article:.The DCL (Data Control Language) commands deal with the permissions, rights and other controls of the database system.The DML (Data Manipulation Language) commands deal with the manipulation of data present in the database.Example: CREATE, DROP, ALTER, TRUNCATE, COMMENT, RENAME. The DDL (Data Definition Language) commands are used to define the database.The topics covered in this article are mainly divided into 4 categories: DDL, DML, DCL
0 Comments
Leave a Reply. |