11_26_2018

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
11_26_2018 [2018/11/26 21:27] – cynthia.kahn11_26_2018 [2018/11/26 21:30] (current) – cynthia.kahn
Line 53: Line 53:
 ); );
  
 +\\ 
 +psql cynthiak   \\
 +\copy users_info FROM '/home/cynthiak/users_tab_to_semi.txt' WITH DELIMITER ';'  \\
  
 +\\ 
 +**//SQL to create table entities_info//**
 +\\ 
 +DROP TABLE IF EXISTS entities_info; \\
 +\\ 
 +CREATE TABLE entities_info( \\
 + hashtags TEXT,
 +  entitiesURL TEXT,
 +  userMentionsID1 BIGINT,
 +  userMentionsID2 BIGINT,
 +  symbols TEXT,
 +  entitiesMediaID BIGINT,
 +  entitiesMediaIndices TEXT,
 +  entitiesMediaURL TEXT,
 +        entitiesType TEXT,
 +        entitiesSizeSmall TEXT,
 +        entitiesSizeMedium TEXT,
 +        entitiesSizeThumb TEXT,
 +        entitiesSizeLarge TEXT,
 +  extendedEntitiesMediaID BIGINT,
 +  extendedEntitiesMediaIndices TEXT,
 +  extendedEntitiesMediaURL TEXT,
 +  extendedDisplayURL TEXT,
 +  extendedExpandedURL TEXT,
 +  extendedEntitiesType TEXT,
 +        extendedSizeSmall TEXT,
 +        extendedSizeMedium TEXT,
 +        extendedSizeThumb TEXT,
 +        extendedSizeLarge TEXT
 +);
 +
 +\\ 
 +psql cynthiak   \\
 +\copy entities_info FROM '/home/cynthiak/entities_table.txt' WITH DELIMITER ';'  \\
  
  • 11_26_2018.txt
  • Last modified: 2018/11/26 21:30
  • by cynthia.kahn