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

Commenti

Post popolari in questo blog