Hi all,
Bit of a random query this, but I have the below query which creates a
table ready to import some data into it:
CREATE TABLE busroutes_raw(
id SEQUENCE PRIMARY KEY,
route VARCHAR,
run INTEGER,
sequence INTEGER,
stop_name VARCHAR,
loation_easting INTEGER,
location_northing INTEGER,
);
I then import the data as below:
COPY busroutes_raw from 'C:/Program Files
(x86)/PostgreSQL/8.4/data/BusRoutes.csv' DELIMITERS ',' CSV;
But I wonder whether it is possible to put a URL as the origin of the
file rather than a path?
Thanks
James