220
edits
Changes
Jump to navigation
Jump to search
→Importing the data
==Importing the data==
To import the data make sure that all 22 crunchbase csv files are on the db server in /bulk/crunchbase/crunchbaseData. Also make sure that the load_crunchbase.sql script is in this directory. Run psql crunchbasebulk to start the db from this directory. Run the command "\i load_crunchbase.sql" to run the script. This will load the contents of the 22 csv files into the db. Check that the number of lines copied into each table matches the actual lines in the csv file. The line numbers have been included in the comments of the load_crunchbase.sql script. See issues section for unexpected results.
Type \dt to get a list of the tables in the crunchbasebulk db.
Type \q to quit db.
When the db is not running you can type 'wc -l acquisitions.csv' to get a line count of this file.
News is a relationship query parameter
