PostgreSQL 7.3.4 Documentation
Prev |  | Next

# insert

## Name

insert -- insert a tuple into a database table

## Synopsis

    insert(table, a)

### Parameters

table

  Name of table.

a

  A dictionary of values.

### Return Type

integer

  The OID of the newly inserted row.

## Description

This method inserts values into the table specified filling in the values from the dictionary. It then reloads the dictionary with the values from the database. This causes the dictionary to be updated with values that are modified by rules, triggers, etc.

Due to the way that this function works you will find inserts taking longer and longer as your table gets bigger. To overcome this problem simply add an index onto the OID of any table that you think may get large over time.

Prev | Home | Next
get | Up | update