Skip site navigation (1) Skip section navigation (2)

PG Admin - Import from URL?

From: James David Smith <james(dot)david(dot)smith(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: PG Admin - Import from URL?
Date: 2012-03-15 15:08:16
Message-ID: CAMu32ACUetBiOUyvrh21=ou+5vHxnOqiV0kjxypMzyhwJcWvJg@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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

Responses

pgsql-novice by date

Next:From: Andreas KretschmerDate: 2012-03-15 16:04:44
Subject: Re: PG Admin - Import from URL?
Previous:From: LewDate: 2012-03-15 14:11:24
Subject: Re: When to choose putting logic into PL/pgSQL and when to use an app server

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group