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.1 reached end of support in April 2006. See the current manual for supported releases.

inserttable

Name

inserttable -- inserts a list into a table

Synopsis

inserttable(table, values)

Parameters

table

The table name (string).

values

The list of rows values to insert (list).

Return Type

none

Exceptions

TypeError

Bad argument type or too many (any) arguments.

pg.error

Invalid connection.

Description

inserttable() method allows to quickly insert large blocks of data in a table: it inserts the whole values list into the given table. The list is a list of tuples/lists that define the values for each inserted row. The rows values may contain string, integer, long or double (real) values. Be very careful: this method does not typecheck the fields according to the table definition; it just look whether or not it knows how to handle such types.

Report a documentation issue

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