[postgis-users] ESRI Shape to Postgres

Wed Feb 24 03:00:07 PST 2010

Khurram Niaz Sheikh wrote:

> Hi,
> 
> I created the database using admin console, I mean rigtclick and create a new database, do I have to create the database using command line, plz advise?
> 
> Regards,
> Khuram

Hi Khuram,

You need to load the postgis.sql and spatial_ref_sys.sql files into your 
database in order to spatially enable it, as per 
http://postgis.refractions.net/documentation/manual-1.5/ch02.html#id2797624.

HTH,

Mark.

-- 
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063

Sirius Labs: http://www.siriusit.co.uk/labs