↑↓ select ↵ open ⌫ change scope Open full search

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

Unsupported versions: 6.4
Historical version. PostgreSQL 6.4 reached end of support in October 2003. See the current manual for supported releases.
PostgreSQL
Prev Chapter 4. The Query Language Next

Populating a Class with Instances

The insert statement is used to populate a class with instances:

INSERT INTO weather
    VALUES ('San Francisco', 46, 50, 0.25, '11/27/1994')

You can also use the copy command to perform load large amounts of data from flat (ASCII) files.

Prev Home Next
Creating a New Class Up Querying a Class

Report a documentation issue

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