select open change scope Open full search

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

Unsupported versions: 6.3
Historical version. PostgreSQL 6.3 reached end of support in March 2003. See the current manual for supported releases.
PostgreSQL
Prev Chapter 13. 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.