Whitebeam Object Definition

Site Map
 
Home
 
Application Guide
Reference
  Installation
  Configuration
  XML Markup
  JavaScript Classes
  ROM
  Templates
  Environment
  Dev Process
  Tools
  External Links
  Example libraries
Community
Contact Whitebeam
To-Do
Download
Credits
Licence
Whitebeam Users
 
 
 

Whitebeam Object Definition

PgsqlConnection Object Description

This JavaScript class encapsulates a connection to a Postgres server to work with a specific database. To use this class, create an instance and then use the connect or pconnect methods to attach to a specific database.

Details of how to us the Whtebeam Postgres interface can be found in our tutorial dealing with this specific topic.

Also see PgsqlResult

Methods

PgsqlConnection.escape() Replace unsafe SQL characters with safe equivalents
PgsqlConnection.binaryEscape() Convert (potentially) unsafe binary data to a safe SQL string (BYTEA types)
PgsqlConnection.binaryUnEscape() Take a safe string representation of a binary object from the database and convert it back to a binary object.
PgsqlConnection.connect() Attach to a Postgres database server.
PgsqlConnection.pconnect() Create a persistent attachement to a Postgres database server.
PgsqlConnection.close() Close an open database connection
PgsqlConnection.exec() Execute SQL on an open database and return a result object
PgsqlConnection.execParams() Execute parameterized SQL on an open database, returning a result object
PgsqlConnection.execParamsArray() Execute parameterized SQL on an open database, returning a result object
PgsqlConnection.openLargeObject() Open an existing Postgres Large Object for reading or writing
PgsqlConnection.createLargeObject() Create a new Large Object in the Postgres Database.

Aggregate Types

PgsqlConnection.connectionDesc

Connection parameters for Postgres databases. An object with the followingg attributes must be passed to either connect or pconnect methods to attach to a database.

Details of how to us the Whtebeam Postgres interface can be found in our tutorial dealing with this specific topic.
Whitebeam release 1.3.36
(loadtime : 11ms)