[postgis-users] shp2pgsql -I option

[Paul Ramsey]

I just ran using the -I option for the first time, and to my  
surprise, the utility seemed to create the index *before* loading the  
data...

Bluejay:~/Desktop pramsey$ shp2pgsql -D -i -I dra_tsa_clip.shp  
dra_tsa_clip | psql
Shapefile type: Arc
Postgis type: MULTILINESTRING[2]
BEGIN
NOTICE:  CREATE TABLE will create implicit sequence  
"dra_tsa_clip_gid_seq" for serial column "dra_tsa_clip.gid"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index  
"dra_tsa_clip_pkey" for table "dra_tsa_clip"
CREATE TABLE
                          addgeometrycolumn
--------------------------------------------------------------------
public.dra_tsa_clip.the_geom SRID:-1 TYPE:MULTILINESTRING DIMS:2
(1 row)

<... no pause here ...>
CREATE INDEX
<... long pause here while data loads ...>
COMMIT