Horje
To ignore duplicate keys during 'copy from' in postgresql Code Example
To ignore duplicate keys during 'copy from' in postgresql 
create temp table tmp_table on commit drop as select * from brand with no data;
copy tmp_table (name,slug) from '/var/lib/postgresql/data/Brands.csv' DELIMITER ',' csv header;
insert into brand select distinct on (slug) * from tmp_table;



Whatever

Related
biodiversity Code Example biodiversity Code Example
pane-active-border-fg Code Example pane-active-border-fg Code Example
TypeError: tempData.findIndex is not a function Code Example TypeError: tempData.findIndex is not a function Code Example
pngquant-bin\vendor\pngquant.exe "ENOENT" "gulp" Code Example pngquant-bin\vendor\pngquant.exe "ENOENT" "gulp" Code Example
how to get absolute value in scala Code Example how to get absolute value in scala Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 7



 

Horje