SELECT INTO Statements

You can use the SELECT INTO statement to export formatted data to a file.

Data Export with an SQL Query

The following query exports data into a file formatted in comma-separated values (CSV):

SELECT Id, Author INTO "csv://AtomFeed.txt" FROM "AtomFeed" WHERE Category = US

You can specify other formats in the file URI. The following example exports tab-separated values:

SELECT * INTO "AtomFeed" IN "csv://filename=c:/AtomFeed.csv;delimiter=tab" FROM "AtomFeed" LIMIT 101