Category Archives: PostgreSQL

PostgreSQL – Import data from CSV

You CSV file similar to the following: The SQL: References: http://forums.enterprisedb.com/posts/list/2819.page http://dba.stackexchange.com/questions/18821/how-to-import-a-csv-file-into-a-postgresql-database-using-copy http://stackoverflow.com/questions/2987433/how-to-import-csv-file-data-into-a-postgres-table http://www.postgresql.org/docs/9.1/static/sql-copy.html http://stackoverflow.com/questions/10079682/copy-function-in-postgresql

PostGIS – 1.5 to 2.0

Just a note, do run ‘legacy.sql‘ when migrate from PostGIS 1.5 to PostGIS 2.0 because there’s functions being removed from 1.5. so we need it back. Reference: http://postgis.refractions.net/docs/PostGIS_FAQ.html#legacy_faq