PostgreSQL - SQL Shell - Import csv file using cmd

Published: 13 May 2019
on channel: Bhaskar Reddy Pulsani

11,691

Create table and import csv file using PostgreSQL Shell:

\! cd

----------------------------------------------------------------

CREATE TABLE public.districts
(
objectid bigserial,
DistrictName text,
inside_x double precision,
inside_y double precision
)

----------------------------------------------------------------

\COPY districts FROM 'Districts.csv' WITH (FORMAT CSV, HEADER);

----------------------------------------------------------------
CSV File:

OBJECTID,DistrictName,INSIDE_X,INSIDE_Y
1,Adilabad,78.56,19.52
2,Bhadradri Kothagudem,80.7,17.68
3,Hyderabad,78.46,17.39
4,Jagtial,78.87,18.83
5,Jangoan,79.27,17.73
6,Jayashankar Bhupalpally,80.16,18.37
7,Jogulamba Gadwal,77.78,16.07
8,Kamareddy,78.06,18.32
9,Karimnagar,79.23,18.38
10,Khammam,80.35,17.19
11,Kumarambheem Asifabad,79.41,19.35
12,Mahabubabad,79.98,17.66
13,Mahabubnagar,77.8,16.7
14,Mancherial,79.51,18.99
15,Medak,78.25,17.95
16,Medchal_Malkajgiri,78.55,17.54
17,Nagarkurnool,78.58,16.38
18,Nalgonda,79.19,16.87
19,Nirmal,78.31,19.11
20,Nizamabad,78.2,18.7
21,Peddapalli,79.45,18.62
22,Rajanna Sircilla,78.76,18.42
23,Rangareddy,78.41,17.13
24,Sangareddy,77.87,17.78
25,Siddipet,78.84,18
26,Suryapet,79.75,17.08
27,Vikarabad,77.74,17.25
28,Wanaparthy,78.03,16.29
29,Warangal_Rural,79.75,17.92
30,Warangal_Urban,79.47,18.02
31,Yadadri Bhuvanagiri,78.98,17.45

On this page of the site you can watch the video online PostgreSQL - SQL Shell - Import csv file using cmd with a duration of hours minute second in good quality, which was uploaded by the user Bhaskar Reddy Pulsani 13 May 2019, share the link with friends and acquaintances, this video has already been watched 11,691 times on youtube and it was liked by 40 viewers. Enjoy your viewing!