PostgreSQL Tutorial
1. How to create new Database in PostgreSQL?
There are two methods of creating a new database:
- CREATE DATABASE (SQL command)
- createdb (command-line executable)
2. What are the different Operators in PostgreSQL?
There are 4 different type of operators in PostgreSQL are as follow-
- Arithmetic operators
- Logic operators
- Comparison operators
- Bitwise operators
3. What are the disadvantages with PostgreSQL?
Performance wise PostgreSQL is slower than MySQL and Open source applications are less than MySQL.
4. How to delete a PostgreSQL database?
- DROP DATABASE (SQL command)
- dropdb (command-line)
PostgreSQL Tutorial
PostgreSQL is one of the most advanced general-purpose Relational database management systems (RDMS). It is open-source software, which means the source code is available under the PostgreSQL license. Anyone with the right skills is free to use, modify, and distribute PostgreSQL in any form. It supports both relational as well as Non-Relational JSON Queries.
In this PostgreSQL tutorial you’ll learn the basic data types(Boolean, char, text, time, int etc.), Querying and Filtering techniques like select, where, in, order by, etc. managing and modifying the tables in PostgreSQL. We’ll cover all the basic to advance concepts of PostgreSQL in this tutorial.
What is PostgreSQL?
PostgreSQL is an advanced and open-source relational database system and is used as a database for many web applications, mobile and analytics applications. It supports both SQL (relational) and JSON (non-relational) querying and It is a stable database supported by more than 20 years of development by the open-source community.
Table of Content
|