PostgreSQL – Expressions An expression is a combination of one or more values, operators, and PostgresSQL functions that evaluate to a value. PostgreSQL EXPRESSIONS are like formulas and they are written in query language. You can also use to query the database for specific set of data. Syntax Consider the basic syntax of the SELECT […]
Category Archives: postgresql
PostgreSQL – Environment Setup To start understanding the PostgreSQL basics, first let us install the PostgreSQL. This chapter explains about installing the PostgreSQL on Linux, Windows and Mac OS platforms. Installing PostgreSQL on Linux/Unix Follow the given steps to install PostgreSQL on your Linux machine. Make sure you are logged in as root before you […]
PostgreSQL – DROP Database In this chapter, we will discuss how to delete the database in PostgreSQL. There are two options to delete a database − Using DROP DATABASE, an SQL command. Using dropdb a command-line executable. Be careful before using this operation because deleting an existing database would result in loss of complete information […]