7,613
edits
Changes
Jump to navigation
Jump to search
The SQL files were generated in MySQL. We need to convert them to PostgreSQL. See: https://en.wikibooks.org/wiki/Converting_MySQL_to_PostgreSQL
→Content
*cb_acquisitions.sql 2309393
*cb_funding_rounds.sql 14681705
'''odm.csv.tar.gz'''
***organization_crunchbase_url
*crunchbase_license.txt 487
==Changing MYSQL to PostgreSQL==
The SQL files were generated in MySQL. We need to convert them to PostgreSQL. See: https://en.wikibooks.org/wiki/Converting_MySQL_to_PostgreSQL and http://stackoverflow.com/questions/1942586/comparison-of-database-column-types-in-mysql-postgresql-and-sqlite-cross-map
The key changes are:
MYSQL POSTGRESQL
----- ----------
LOCK --comment out as no need but LOCK [ TABLE ] [ ONLY ] name [ * ] [, ...] [ IN lockmode MODE ] [ NOWAIT ]
UNLOCK --comment out
decimal(x,y) real (might work as is)
datetime timestamp
KEY --comment out as no need but FOREIGN KEY ( column_name [, ... ] ) REFERENCES reftable [ ( refcolumn [, ... ] ) ]
