www.openlinksw.com
docs.openlinksw.com

Book Home

Contents
Preface

Virtuoso Functions Guide

Administration
Aggregate Functions
Array Manipulation
BPEL APIs
Backup
Compression
Cursor
Date & Time Manipulation
Debug
Dictionary Manipulation
Encoding & Decoding
File Manipulation
file_delete
file_dirlist
file_mkdir
file_mkpath
file_stat
file_to_string
file_to_string_outpu...
file_unlink
gz_file_open
os_chmod
os_chown
Free Text
Hashing / Cryptographic
LDAP
Locale
Mail
Miscellaneous
Number
Phrases
RDF data
Remote SQL Data Source
Replication
SOAP
SQL
String
Transaction
Type Mapping
UDDI
User Defined Types & The CLR
Virtuoso Java PL API
Virtuoso Server Extension Interface (VSEI)
Web & Internet
XML
XPATH & XQUERY

Functions Index

gz_file_open

returns the contents of a gzipped file
varchar gz_file_open (in path varchar);
Description

Returns the contents of a file. The path is relative to the working directory of the database server.

Parameters
path – Path name of the file to read.
Examples

For loading gzipped N3 and Turtle files you can use:

SQL>DB.DBA.TTLP_MT (gz_file_open('/path/myfile.n3.gz'), 'base uri', 'graph uri', 255);

Note that the last parameter means the parser uses relaxed parsing rules, the default value of 0 means strict syntax rules.