Skip to main content

Vortex Extension

The vortex extension allows you to read and write files using the Vortex file format. It is currently available for the Linux (linux_amd64, linux_arm64) and macOS (osx_amd64, osx_arm64) distributions.

Installing and Loading​

To install and load the extension, run:

INSTALL vortex;
LOAD vortex;

Reading Vortex Files​

Using the read_vortex function to read Vortex files:

SELECT * FROM read_vortex('my.vortex');
┌───────┐
│   i   │
│ int64 │
├───────┤
│     0 │
│     1 │
│     2 │
└───────┘

Writing Vortex Files​

You can write Vortex files as follows:

COPY (SELECT * FROM generate_series(0, 3) t(i))
TO 'my.vortex' (FORMAT vortex);

Warning Make sure to add the FORMAT vortex option. If the vortex extension is not loaded, using COPY ... TO 'my.vortex without the FORMAT vortex specifier will result in a CSV file.