Online Documentation Server
 ПОИСК
ods.com.ua Web
 КАТЕГОРИИ
Home
Programming
Net technology
Unixes
Security
RFC, HOWTO
Web technology
Data bases
Other docs

 


 ПОДПИСКА

 О КОПИРАЙТАХ
Вся предоставленная на этом сервере информация собрана нами из разных источников. Если Вам кажется, что публикация каких-то документов нарушает чьи-либо авторские права, сообщите нам об этом.




Populating a Class with Instances

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.



With any suggestions or questions please feel free to contact us