Importing into PostgreSQL

To import the annotations into PostgreSQL, connect to the Postgres server with psql and run the following commands:

Note: this is a work in progress, and it's known to be incomplete and suboptimal. Suggestions to improve it are very welcome!

postgres=# CREATE DATABASE openimages;
CREATE DATABASE
postgres=# CREATE TABLE Images (ImageID VARCHAR, Subset VARCHAR, OriginalURL VARCHAR, OriginalLandingURL VARCHAR, License VARCHAR, AuthorProfileURL VARCHAR, Author VARCHAR, Title VARCHAR);
CREATE TABLE
postgres=# COPY Images FROM 'images_2016_08/validation/images.csv' DELIMITER ',' CSV HEADER;
COPY 167056
postgres=# COPY Images FROM '/home/krasin/v2/images_2016_08/train/images.csv' DELIMITER ',' CSV HEADER;
COPY 9011219

You can now verify that import was successful:

postgres=# SELECT Subset, count(*) FROM Images GROUP BY Subset;
   subset   |  count  
------------+---------
 train      | 9011219
 validation |  167056
(2 rows)

TODO: import labels.