Home → Documentation → Manuals → PostgreSQL 9.6

This page in other versions: 9.3 / 9.4 / 9.5 / 9.6 / current (10) | Development versions: devel / 11 | Unsupported versions: 9.1 / 9.2

PostgreSQL 9.6.10 Documentation
Prev	Up		Next

VAR

Name

VAR -- define a variable

Synopsis

VAR varname IS ctype

Description

The VAR command assigns a new C data type to a host variable. The host variable must be previously declared in a declare section.

Parameters

varname: A C variable name.
ctype: A C type specification.

Examples

Exec sql begin declare section;
short a;
exec sql end declare section;
EXEC SQL VAR a IS int;

Compatibility

The VAR command is a PostgreSQL extension.

Prev	Home	Next
TYPE	Up	WHENEVER

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.