Pgloader -- How to load constant while using load csv

Question

I am using pgloader to load file into Tables. I need to load constant (ie, field not provided by the csv) but I do not succeed.

my configuration looks like :

LOAD CSV  
  FROM './file.csv'
  HAVING FIELDS
  (a, b, c)
INTO postgresql:///pgloader?my_table
  TARGET COLUMNS
  (
    a
    ,b   
    ,c  
    ,Src
  )
  WITH
    skip header = 0,  
    fields optionally enclosed by '"',  
    fields escaped by double-quote,  
    fields terminated by ';'  
;

and I need to put 'SRC' static value into the field my_table.Src.

Do you have any idea?

Thanks.

regards,

-- Julien

Add a line in your import script, `UPDATE my_table SET constant_field='the constant value';` — Peter Krauss, Jan 27 '18 at 22:08

score 1 · Accepted Answer · answered Oct 25 '22 at 12:49

1

Just use the 'using' instruction

LOAD CSV  
  FROM './file.csv'
  HAVING FIELDS
  (a, b, c)
INTO postgresql:///pgloader?my_table
  TARGET COLUMNS
  (
    a,
    b,   
    c,  
    Src text using "SRC"
  )
  WITH
    skip header = 0,  
    fields optionally enclosed by '"',  
    fields escaped by double-quote,  
    fields terminated by ';'  
;

answered Oct 25 '22 at 12:49

Jerome

1,153
1
17
28

can be variabilized using templating : ```Src text using "{{VAR_SRC}}"``` – Julien Oct 26 '22 at 13:46

Pgloader -- How to load constant while using load csv

1 Answers1