Import CSV in Postgres with static data in other columns

How can I COPY CSV file in Postgres along with static data for the columns not in the CSV? For example in MySQL I can do something like LOAD DATA INFILE ... and profile the column names along with any values for the columns not present in the file. Want to do something similar with Postgres but since this is not supported by the COPY command, I can't seem to figure out how to work on that. Any pointers suggestions would be welcome.



Category: postgresql Time: 2016-07-29 Views: 1
Tags: postgresql

Related post

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development


Front-end development


development tools

Open Platform

Javascript development

.NET development

cloud computing


Copyright (C), All Rights Reserved.

processed in 0.296 (s). 12 q(s)