This document discusses PostgreSQL Data Types. While creating table, for each column, you specify a data type, i.e. what kind of data you want to store.
May 3, 2013
·
9:00 AM
This document discusses how to delete data of a table using PostgreSQL DELETE command.
May 3, 2013
·
9:00 AM
The PostgreSQL DISTINCT clause is used with SELECT statement to suppress duplicate values if any in a column. After execute a select statement the resultant table returns all rows according to the...
May 3, 2013
·
9:00 AM
A FOREIGN KEY constraint contain the value in a column or combination of columns which must be appearing in the same column or group of columns in another table.
May 3, 2013
·
9:00 AM
The group by clause is used to divide the rows in a table into smaller groups that have the same values in the specified columns. This clause is used with SELECT statement to combine a group of...
May 3, 2013
·
9:00 AM
The HAVING clause is used to specify which individual group(s) are to be displayed, that is , the desire groups that you return on the basis of aggregate functions.
May 3, 2013
·
9:00 AM
This document discusses how to insert data into a table using PostgreSQL INSERT command. We have also covered how to do the same using PHP-PostgreSQL.KJVQCSV69JFX
May 3, 2013
·
9:00 AM
The main concept which is focusing on a join is that, two or more data sets, when joined, combined there columns into a new set of rows, including each of the columns requested from each of the...
May 3, 2013
·
9:00 AM
The AND, OR, and NOT keywords are PostgreSQL's Boolean operators. These keywords are mostly used to join or invert conditions in a SQL statement, specifically in the WHERE clause and...
May 3, 2013
·
9:00 AM
A mathematical function operates on input values ( numeric ) which are provided as arguments, and return a numeric value as the output of that operation. Mathematical functions operates on numeric...
May 3, 2013
·
9:00 AM
