User Tools

Site Tools


reference:vpop3.postgresquery

VPOP3.PostgresQuery

The Lua function 'VPOP3.PostgresQuery' performs a query on the PostgreSQL database and returns the results in a table

It takes a single parameter which is the SQL query to perform (Note that any relations used in the query must have the schema specified).

The function returns two values. The first is a table containing the result, and the second is the result code of the query (0 for success)

The result table is:

[Rows: <number of rows returned>, 1: [col1: data1, col2: data2, etc (1st row results)], 2: [<2nd row results>], etc]
reference/vpop3.postgresquery.txt · Last modified: 2018/11/14 10:45 (external edit)