COPY BZ2 Compressed Files?

[Julie]

Hey,

Can we use the copy command with files that are BZ2 compressed? I tried the BZIP option, but am getting an error.

Thank you!

[NorbertKrupa]

What is the syntax you're using? What error are you getting?

See the documentation for an example:

Code: Select all

\! bzip2 pf1.dat
\! cat pf1.dat.bz2 > pipe1 &
COPY large_tbl FROM :file ON site01 BZIP delimiter '|'; 
SELECT * FROM large_tbl; 
COMMIT;
bunzip2 pf1.dat.bz2

[Julie]

Norbert, thanks for the reply! I looked at your example and realized I had the BZIP keyword in the wrong location of the copy command. It has to be right after the file name; I had it at the end after the DIRECT keyword. After I moved it, I was able to load the data. Duh!