Data Imported Without the Time Field

Uqbar supports data import without the time field. For data imported without the time field, the server system time is used as the time field. If the insertion time is not specified in the INSERT syntax, the database time when the data is inserted is used as the insertion time.

The precision of timestamp is ms. Users can also specify the number of digits after the decimal point using the now()::timestamp(x) syntax. For example, timestamp(3) indicates that there are three digits kept after the decimal point.

Syntax

INSERT INTO table VALUES [, ...];

Examples

Uqbar=# INSERT INTO weather(city, location, temperature) VALUES('beijing', 'chaoyang', 29.1);
INSERT 0 1