[postgis-users] load csv file in data base?

Andreas Neumann a.neumann at carto.net
Tue Feb 17 23:35:15 PST 2009

Hi Zia,

As Michael said, the postgresql COPY command is a standard way from 
PostgreSQL to import CSV data. You can specify the columns, delimiter, 
NULL values, quotes and other parameters and it will stop and report 
errors if a line does not fit the data-types of the defined tables.

Often, loading CSV files can be tricky, if the people who created the 
file did not strictly stick to the data-types, delimiters or did not 
strictly quote text the same throughout the file. It would need some 
manual editing or a script correcting the file then.


Zia Ahmed wrote:
> How do I load csv file in database? If some know please help me .
> Thanks
> Zia
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

More information about the postgis-users mailing list