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.3 reached end of support in November 2007. See the current manual for supported releases.

clear

Name

clear -- clear a database table

Synopsis

clear(table, [a])

Parameters

table

Name of table.

[a]

A dictionary of values.

Return Type

dictionary

A dictionary with an empty row.

Description

This method clears all the attributes to values determined by the types. Numeric types are set to 0, dates are set to 'today' and everything else is set to the empty string. If the array argument is present, it is used as the array and any entries matching attribute names are cleared with everything else left unchanged.

Report a documentation issue

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