How to import data into table PostgreSQL, through download data directly from site.
How to import data into table PostgreSQL, through download data directly from site.
Example.
ghost@linuxpc# CREATE TABLE Earthmoving (
region text,
country text,
year int,
hours int,
fuel int
);
CREATE TABLE
COPY Earthmoving FROM PROGRAM '
curl https://mysite.com/myfolder/Earthmoving.txt';
COPY 644
#postgresql #linux #sql #ethicalhacker #dba #database #programming
Example.
ghost@linuxpc# CREATE TABLE Earthmoving (
region text,
country text,
year int,
hours int,
fuel int
);
CREATE TABLE
COPY Earthmoving FROM PROGRAM '
curl https://mysite.com/myfolder/Earthmoving.txt';
COPY 644
#postgresql #linux #sql #ethicalhacker #dba #database #programming
Commenti
Posta un commento