EnterpriseDB
  • Home
  • Category
    Installation & Getting Started Quick Start Reference User Guides
  • Product
    EDB Backup and Recovery Tool EDB JDBC Connector EDB .NET Connector EDB OCL Connector EDB ODBC Connector EDB*Plus EDB Postgres Advanced Server EDB Postgres Ark Platform EDB Postgres Cloud Database Service EDB Postgres Enterprise Manager EDB Postgres Failover Manager EDB Postgres Hadoop Foreign Data Wrapper EDB Postgres Language Pack EDB Postgres Migration Portal EDB Postgres Migration Toolkit EDB Postgres MongoDB Foreign Data Wrapper EDB Postgres MySQL Foreign Data Wrapper EDB Postgres PgBouncer EDB Postgres Pgpool-II EDB Postgres PostGIS EDB Postgres Replication Server EDB Postgres Slony Replication PostgreSQL pgAdmin 4

EDB Postgres Advanced Server → 11 → Reference → Database Compatibility for Oracle® Developers Reference Guide
Other versions of this page: 12 · 11 · 10 · 9.6

Get Postgres Tips and Tricks

Subscribe to get advanced Postgres how-tos.

Table of Contents Previous Next


4 System Catalog Tables : 4.6 edb_variable

4.6 edb_variable
The edb_variable table contains one row for each package level variable (each variable declared within a package).
Column
Type
Modifiers
Description
varname
"name"
not null
The name of the variable.
varpackage
oid
not null
The OID of the pg_namespace row that stores the package.
vartype
oid
not null
The OID of the pg_type row that defines the type of the variable.
varaccess
"char"
not null
+ if the variable is visible outside of the package.
- if the variable is only visible within the package.
Note: Public variables are declared within the package header; private variables are declared within the package body.
varsrc
text
Contains the source of the variable declaration, including any default value expressions for the variable.
varseq
smallint
not null
The order in which the variable was declared in the package.

4 System Catalog Tables : 4.6 edb_variable

Table of Contents Previous Next
© 2021 EnterpriseDB Corporation. All rights reserved. | Privacy Policy | Terms of Use | Trademarks