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.

Thanks.

Replay

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

search

Front-end development

Database

development tools

Open Platform

Javascript development

.NET development

cloud computing

server

Copyright (C) avrocks.com, All Rights Reserved.

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