CREATE TABLE To create a new table in a PostgreSQL database, one can use the UI or can also use the PostgreSQL CREATE TABLE statement. Syntax: CREATE TABLE table_name ( column_1 data_type column_constraint, column_2 data_type column_constraint, … ); Creating a TABLE using UI: Select the database. To get the catalogues and schema, left-click on the … Read more

DROP DATABASE To drop or eliminate a particular PostgreSQL database, one can either use the UI or can delete or remove the PostgreSQL database using the DROP database command. Syntax: DROP DATABASE name; Parameters: name: It is used to specify the name of the database to be eliminated. Example: DROP DATABASE country;DROP DATABASE country; Explanation: … Read more

CREATE DATABASE Creating a database using command: Syntax: CREATE DATABASE name; Parameters: name: It is used to specify the name of the database to be created. Example: CREATE DATABASE students;CREATE DATABASE students; Explanation: A new database will be created with the name ‘students’. Creating a database using UI: Go to start menu. Click on the … Read more

Install PostgreSQL To install PostgreSQL on Windows. Select the version number of PostgreSQL and download it from the link: http://www.enterprisedb.com/products-services-training/pgdownload#windows Turn off the third-party antivirus while installing. Run the downloaded .exe file as an administrator to install PostgreSQL. Select the location to install the file, or it will install within the Program File Folder, by … Read more

PostgreSQL Data Types It is necessary to specify the type of data that can be stored and processed in a PostgreSQL database along with the specification of the type of operations that can be performed on that type of data. This purpose is served by the various data types supported by the PostgreSQL database including … Read more

PostgreSQL Syntax To check the syntax of all PostgreSQL commands, one can take the help of the HELP command by following the below steps.   After the successful installation of PostgreSQL, open the SQL. Program Files > PostgreSQL 9.2 > SQL Shell(psql)   To see the syntax of a specific command. Command: postgres-# \help &<command_name> … Read more

PostgreSQL Features Some of the unique yet important features of PostgreSQL are listed below. Runs on all major operating systems including Linux, UNIX and Windows. Supports text, images, sounds, and video. Includes programming interfaces for C / C++, Java, Perl, Python, Ruby, Tcl and Open Database Connectivity (ODBC). Supports many features of SQL including some … Read more

PostgreSQL History PostgreSQL is currently the most advanced open-source database available in the world. It was started in 1986 to overcome the problems of the contemporary database system. It was created by a computer science professor named Michael Stonebraker at UCB and was originally called Postgres, as it was started as a follow-up project and … Read more