REQUEST COMPLIMENTARY SQLS*PLUS LICENCE
PostgreSQL variables
In this tutorial, you will learn how to declare variables in PostgreSQL using syntax and examples.
What is a variable in PostgreSQL?
In PostgreSQL, a variable allows a programmer to temporarily store data at runtime.
The syntax for declaring a variable in PostgreSQL
DECLARE variable_name [ CONSTANT ] datatype [ NOT NULL ] [ { DEFAULT |:= } initial_value ]
Parameters and arguments of variables
- variable_name – The name to be assigned to the variable.
- CONSTANT – Optional. If specified, the variable value cannot be changed after the initialization of the variable.
- datatype – The data type to be assigned to a variable.
- NOT NULL – Optional. If specified, the variable cannot contain the value of NULL.
- initial_value – Optional. This is the value originally assigned to a variable when it is declared. If no
- initial_value is specified, the variable is assigned a value of NULL.
Declaring a variable
Below is an example of a PostgreSQL declaration of a variable with vSite name.
DECLARE vSite varchar;
In this example, the variable vSite is declared as the varchar data type.
Then you can later set or change the value of the vSite variable as follows:
vSite:= 'Google.com';
This operator will set the vSite variable to ‘Google.com’.
Declaring a variable with an initial value (not a constant)
Below is an example of how to declare a variable in PostgreSQL and give it an initial value. This differs from the constant in that the variable value can be changed later.
DECLARE vSite varchar DEFAULT 'Google.com';
OR:
DECLARE vSite varchar:= 'Google.com';
This will declare the variable named vSite as varchar data type and assign the initial value to ‘Google.com’.
Later you can change the value of the vSite variable as follows:
vSite:= 'Bing.com';
This SET operator will change the value of the vSite variable from ‘Google.com’ to ‘Bing.com’.
Declaring a constant
Here is an example of how to declare a constant in PostgreSQL with the name vSiteID.
DECLARE vSiteID CONSTANT integer DEFAULT 50;
OR:
DECLARE vSiteID CONSTANT integer:= 50;
This will declare a constant named vSiteID as integer data type and assign an initial value of 50. Since this variable is declared using the CONSTANT keyword, you cannot change its value after initializing the variable.
Learn PostgreSQL Tutorial – Full Course for Beginners
MORE NEWS
PreambleNoSql is not a replacement for SQL databases but is a valid alternative for many situations where standard SQL is not the best approach for...
PreambleMongoDB Conditional operators specify a condition to which the value of the document field shall correspond.Comparison Query Operators $eq...
5 Database management trends impacting database administrationIn the realm of database management systems, moreover half (52%) of your competitors feel...
The data type is defined as the type of data that any column or variable can store in MS SQL Server. What is the data type? When you create any table or...
PreambleMS SQL Server is a client-server architecture. MS SQL Server process starts with the client application sending a query.SQL Server accepts,...
First the basics: what is the master/slave?One database server (“master”) responds and can do anything. A lot of other database servers store copies of all...
PreambleAtom Hopper (based on Apache Abdera) for those who may not know is an open-source project sponsored by Rackspace. Today we will figure out how to...
PreambleMongoDB recently introduced its new aggregation structure. This structure provides a simpler solution for calculating aggregated values rather...
FlexibilityOne of the most advertised features of MongoDB is its flexibility. Flexibility, however, is a double-edged sword. More flexibility means more...
PreambleSQLShell is a cross-platform command-line tool for SQL, similar to psql for PostgreSQL or MySQL command-line tool for MySQL.Why use it?If you...
PreambleWriting an application on top of the framework on top of the driver on top of the database is a bit like a game on the phone: you say “insert...
PreambleOracle Coherence is a distributed cache that is functionally comparable with Memcached. In addition to the basic function of the API cache, it...
PreambleIBM pureXML, a proprietary XML database built on a relational mechanism (designed for puns) that offers both relational ( SQL / XML ) and...
What is PostgreSQL array? In PostgreSQL we can define a column as an array of valid data types. The data type can be built-in, custom or enumerated....
PreambleIf you are a Linux sysadmin or developer, there comes a time when you need to manage an Oracle database that can work in your environment.In this...
PreambleStarting with Microsoft SQL Server 2008, by default, the group of local administrators is no longer added to SQL Server administrators during the...