Hello , This table keep all geometry type (point , polygon, linestring). Your data is including all of them I think. Could you send your csv data . I will try insert into a spatial table maybe. CREATE TABLE mygis_table ( objectid serial not null, poly geometry(Geometry,4326), CONSTRAINT mygis_table_pkey PRIMARY KEY (objectid) ) WITH ( OIDS=FALSE ); ALTER TABLE mygis_table OWNER TO postgres; -- Index: "gixB19E787C" -- DROP INDEX "gixB19E787C"; CREATE INDEX "gixB19E787C" ON mygis_table USING gist (poly); I hope I will help you. Best wishes. -----Original Message----- From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Rose Beck Sent: Thursday, March 10, 2016 8:39 AM To: pgsql-admin@xxxxxxxxxxxxxx Subject: Importing csv files containing multiple geometries in postgis I have the following data in tab delimited csv file (containing latitude and longitude of places): <place1> <geo> "POLYGON((-5.8335446 43.3655635,-5.8336337 43.3655207,-5.8349218 43.3673341,-5.8345197 43.3674013,-5.8336182 43.3660938,-5.8335037 43.365924,-5.8334505 43.3658461,-5.8334702 43.3657311,-5.8335446 43.3655635))" . <place2> <geo> "POINT((-5.8374796 43.3687922))" . <place3> <geo> "LINESTRING((-5.8427265 43.3678474,-5.8421236 43.3677908))" . <place4> <geo> "MULTIPOINT((-5.8445678 43.3589236,-5.8435222 43.358205,-5.8429834 43.3575551,-5.8429127 43.3572642))" . I want to import this data into postgis. In order to do so, I need to create a table in my database first. I know I can create a table for one specific geometry(e.g. for POINT) using: create table myTable (firstColumn varchar(100)); SELECT AddGeometryColumn( 'myTable', 'geom', 4269, 'POINT', 2 ); But I am not able to understand as to how can I import my csv file containing varied geometries into postgres in a single table in a single column myTable. I also want to construct a single "gist" index on the top of myTable -- With Warm Regards, Rose -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin SELCUK AYDIN PROJE UZMANI selcuk.aydin@xxxxxxxxxxxxx Cyber Park B Blok No:409 06800, Bilkent / Ankara Tel. :(312) 265 0510 - 1192 Faks: (312) 265 0520 [NETCAD] <http://www.netcad.com.tr/> -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin