[postgis-users] load csv file in data base?
a.neumann at carto.net
Tue Feb 17 23:35:15 PST 2009
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 .
> postgis-users mailing list
> postgis-users at postgis.refractions.net
More information about the postgis-users