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.
Andreas
Zia Ahmed wrote:
How do I load csv file in database? If some know please help me .
Thanks
Zia
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
