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