filmov
tv
PostgreSQL - SQL Shell - Import csv file using cmd
Показать описание
Create table and import csv file using PostgreSQL Shell:
\! cd
----------------------------------------------------------------
(
objectid bigserial,
DistrictName text,
inside_x double precision,
inside_y double precision
)
----------------------------------------------------------------
----------------------------------------------------------------
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
\! cd
----------------------------------------------------------------
(
objectid bigserial,
DistrictName text,
inside_x double precision,
inside_y double precision
)
----------------------------------------------------------------
----------------------------------------------------------------
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
0:09:43
PostgreSQL (1) Installation and Create Your First Database ( SQL shell / PgAdmin4 )
0:03:37
Create database schema using sql shell(psql) command prompt in postgreSQL - PostgreSQL Tutorial
0:00:29
PostgreSQL - SQL Shell - Connect to database
0:07:40
#Psql Commands #Database commands in SQL Shell #Postgresql
0:00:23
PostgreSQL - SQL Shell - Show all databases
0:00:19
PostgreSQL - SQL Shell - Clear Screen
0:00:15
Connect to PostgreSQL with SQL Shell
0:00:17
PostgreSQL - How to set or change PostgreSQL user password
1:06:21
Pongo, using PostgreSQL as a strongly-consistent Document Database
0:05:30
How to Connect to the Database in PostgreSQL using SQL Shell | PostgreSQL SQL Shell|#postgresqlshell
0:00:30
PostgreSQL - SQL Shell - Show working directory and List all files
0:00:25
PostgreSQL - SQL Shell - List all Views
0:01:59
Create database in postgreSQL Server Using SQL Shell command prompt interface -PostgreSQL Tutorial
0:00:16
PostgreSQL - SQL Shell - List all users
0:00:56
PostgreSQL - SQL Shell - Change postgresql password
0:00:16
PostgreSQL - Exit SQL Shell using command
0:06:02
#tutorial Create Database, Table with SQL Shell (psql) Windows 11, 2023 #postgresql #createdatabase
0:00:16
PostgreSQL - SQL Shell - List all functions
0:02:24
connect or switch between databases using SQL Shell psql in PostgreSQL Server - PostgreSQL Tutorial
0:00:27
PostgreSQL - SQL Shell - List all psql commands
4:19:34
Learn PostgreSQL Tutorial - Full Course for Beginners
0:00:28
PostgreSQL - SQL Shell - Get Table Information
PostgreSQL - SQL Shell - Import csv file using cmd
0:13:38
PostgreSQL Tutorial (CMD/TERMINAL): CRUD - CREATE, READ, UPDATE, DELETE
Комментарии