select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Unsupported versions: 7.3 / 7.2 / 7.1
Historical version. PostgreSQL 7.2 reached end of support in February 2007. See the current manual for supported releases.

dictresult

Name

dictresult -- like getresult but returns a list of dictionaries

Synopsis

dictresult()

Parameters

none

Return Type

list

List of dictionaries.

Exceptions

SyntaxError

Too many arguments.

pg.error

Invalid previous result.

Description

dictresult() method returns the list of the values returned by the query with each tuple returned as a dictionary with the field names used as the dictionary index.

Report a documentation issue

Read the upstream documentation. For corrections, first check the current manual.