An aggregate function produced a single result for an entire group or table.
May 3, 2013
·
9:00 AM
The PostgreSQL ALTER TABLE statement is used to change the definition or structure of an existing table.
May 3, 2013
·
9:00 AM
The AVG function determines the average of all selected values of a column.
May 3, 2013
·
9:00 AM
The PostgreSQL CHECK constraint controls the value of a column(s) being inserted.The PostgreSQL provides the CHECK constraint, which allows the user to define a condition, that a value entered...
May 3, 2013
·
9:00 AM
Comparison operators, as their name, allows to compare two values. It Compares strings or numbers for relationships such as equality.
May 3, 2013
·
9:00 AM
Constraints are a part of the table definition that limit the values inserted into its columns.Which type of data a table can store that may be decided by the type of data. That is why CONSTRAINTS...
May 3, 2013
·
9:00 AM
The PostgreSQL COUNT function counts number of rows or non-NULL values against a specific column from a table.
May 3, 2013
·
9:00 AM
This document discusses how to create database in PostgreSQL using command line, pgAdmin III and phppgAdmin. For ease of understanding, each process is complemented by screenshots taken while doing.
May 3, 2013
·
9:00 AM
This document discusses how to create table in PostgreSQL using command line, pgAdmin III and phppgAdmin. For ease of understanding, each process is complemented by screenshots taken while doing.
May 3, 2013
·
9:00 AM
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
