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.kahn
11_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