FRENDS⁴ Common Components : PostgreSQL .QueryData

Executes a stored procedure or a command

Parameter

Description

Example

Query

PostgreSQL query

Normal query requires double quotes around Column and 2 single quotes around Value. Example:

" SELECT * FROM table WHERE \"Column\" = ''Value'' "

Query with parameters example: " SELECT * FROM table WHERE \"Column\" = '||:Value||' "

Query return type

Enum value	Description
Xmlstring	Result value in XML
Xmldocument	Result value as Xmldocument
XDocument	Result values as XDocument object
Jsonstring	Result values as Jsonstring
Dynamic	Result values as Dynamic object

Parameters

List of name/value pairs to use as parameters

"Value" : "123"

Connection string

The connection string to use

"Server=111.194.49.222;Port=5432;Database=el_efe;User Id=user;Password=1234;"

Timeout seconds

The command timeout

30