Assalamualaikum / Hi, Today, I just accidentally drop a database with size of about 2GB. To load it back to database gonna took long hours.
read morePLEASE MAKE SURE YOU BACKUP YOUR PUBLIC SCHEMA ! Steps: Open up pgAdmin III and connect to PostgreSQL. Select desired database and click on schemas
read moreCopy & Paste the result in your MySQL editor and execute the SQL. References http://stackoverflow.com/questions/7691816/group-concat-comma-separator-mysql http://stackoverflow.com/questions/893874/mysql-determine-tables-primary-key-dynamically/893922#893922 http://mysql-0v34c10ck.blogspot.com/2011/05/better-way-to-get-primary-key-columns.html
read moreYou 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
read more