Skip to content

Instantly share code, notes, and snippets.

@peterbe

peterbe/gist:8699219

Created January 29, 2014 23:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save peterbe/8699219 to your computer and use it in GitHub Desktop.
Save peterbe/8699219 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
airmozilla=# select user_id, url, file_name, size, suggested_event_id from uploads_upload;
user_id | url | file_name | size | suggested_event_id
---------+----------------------------------------------------------------------------+---------------------------------------------------------+----------+--------------------
5 | https://air-mozilla-uploads.s3.amazonaws.com/2014/01/14/5-61899-235618.jpg | photo 4.JPG | 6411384 |
5 | https://air-mozilla-uploads.s3.amazonaws.com/2014/01/15/5-61899-180720.jpg | photo 4.JPG | 6411384 |
5 | https://air-mozilla-uploads.s3.amazonaws.com/2014/01/14/5-71763-235928.csv | Analytics All Web Site Data Pages 20131223-20140102.csv | 1237 | 97
5 | https://air-mozilla-uploads.s3.amazonaws.com/2014/01/15/5-61899-003516.jpg | photo 4.JPG | 6411384 |
5 | https://air-mozilla-uploads.s3.amazonaws.com/2014/01/24/5-88c67-222402.jpg | 2014-01-17 18.47.41.jpg | 2744609 |
5 | https://air-mozilla-uploads.s3.amazonaws.com/2014/01/24/5-f7d6d-223131.jpg | 2014-01-07 07.12.36.jpg | 3280995 |
5 | https://air-mozilla-uploads.s3.amazonaws.com/2014/01/24/5-4b349-223237.jpg | 2014-01-01 07.28.06.jpg | 3218139 | 98
5 | https://air-mozilla-uploads.s3.amazonaws.com/2014/01/24/5-8a8ac-224702.jpg | 2014-01-18 09.54.51.jpg | 10427301 | 99
5 | https://air-mozilla-uploads.s3.amazonaws.com/2014/01/24/5-84375-225439.xls | SpreedlyPricing-bdea91bcdf9f666bb82d14b1484240c7.xls | 10752 |
5 | https://air-mozilla-uploads.s3.amazonaws.com/2014/01/24/5-5ae0c-234201.jpg | photo.JPG | 102678 |
5 | https://air-mozilla-uploads.s3.amazonaws.com/2014/01/24/5-6263a-234312.csv | Analytics All Web Site Data Pages 20140103-20140111.csv | 899 | 101
5 | https://air-mozilla-uploads.s3.amazonaws.com/2014/01/24/5-f7d6d-223207.jpg | 2014-01-07 07.12.36.jpg | 3280995 | 102
(12 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment