SamirMjs

PGloader - How to pass connection string in pgloader as environment variables

3

LOAD CSV FROM '/dbf/appworx/pgscript/temp_table_data.csv' (INV_ID) INTO postgresql://username:password@hostname:portname/dbname TARGET TABLE temp_inv_table Running through shells script - #!/bin/ksh echo "Start" #enviroment variable . /xzy/DBset echo "Fetching password value" pgloader temp_table_load2.load How do...

We have issue while setting default value. Right now we are doing at Table level. Let me know how do set "Current_date", Nextval to default coumns