sample.csv

sample.load

LOAD CSV
    FROM stdin (
    pageid, createDate, archive, label, crawlid,
    wptid, wptrun, url, urlShort, urlhash,
    cdn [null if '\N'],
    startedDateTime,
    TTFB [null if '\N'],
    renderStart,
    onContentLoaded [null if '\N'],
    onLoad, fullyLoaded, visualComplete, PageSpeed [null if '\N'], SpeedIndex [null if '\N'],
    rank [null if '\N'], reqTotal, reqHtml, reqJS, reqCSS,
    reqImg, reqGif, reqJpg, reqPng, reqFont,
    reqFlash, reqJson, reqOther, bytesTotal, bytesHtml,
    bytesJS, bytesCSS, bytesImg, bytesGif, bytesJpg,
    bytesPng, bytesFont, bytesFlash, bytesJson, bytesOther,
    bytesHtmlDoc, numDomains, maxDomainReqs, numRedirects, numHttps,
    numGlibs, numErrors, numCompressed, numDomElements, maxageNull,
    maxage0, maxage1, maxage30, maxage365, maxageMore,
    gzipTotal, gzipSavings, _connections, _adult_site, avg_dom_depth,
    document_height, document_width, localstorage_size, sessionstorage_size, num_iframes,
    num_scripts, doctype, meta_viewport)

    INTO postgresql://postgres@localhost/?nullif (
    id, doctype
    )

    WITH
        fields optionally enclosed by '"',
        fields escaped by backslash-quote,
        fields terminated by ','

    BEFORE LOAD DO
      $$ drop table if exists nullif; $$,
      $$ CREATE TABLE nullif
         (
            id     serial primary key,
            doctype   text
         );
      $$


;