This page in other versions: Unsupported versions: 7.0

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. This is usually faster because the data is read (or written) as a single atomic transaction directly to or from the target table. An example would be:

COPY weather FROM '/home/user/weather.txt'
    USING DELIMITERS '|';
    
where the path name for the source file must be available to the backend server machine, not the client, since the backend server reads the file directly.
Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group