PostgreSQL – DELETE Query The PostgreSQL DELETE Query is used to delete the existing records from a table. You can use WHERE clause with DELETE query to delete the selected rows. Otherwise, all the records would be deleted. Syntax The basic syntax of DELETE query with WHERE clause is as follows − DELETE FROM table_name […]
Category Archives: postgresql
PostgreSQL – CREATE Database This chapter discusses about how to create a new database in your PostgreSQL. PostgreSQL provides two ways of creating a new database − Using CREATE DATABASE, an SQL command. Using createdb a command-line executable. Using CREATE DATABASE This command will create a database from PostgreSQL shell prompt, but you should have […]
PostgreSQL – SELECT Database This chapter explains various methods of accessing the database. Assume that we have already created a database in our previous chapter. You can select the database using either of the following methods − Database SQL Prompt OS Command Prompt Database SQL Prompt Assume you have already launched your PostgreSQL client and […]