Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
11_12_2018 [2018/11/14 21:54] – cynthia.kahn | 11_12_2018 [2018/11/14 22:01] (current) – cynthia.kahn | ||
---|---|---|---|
Line 11: | Line 11: | ||
sed -i ' | sed -i ' | ||
string = string.replace(" | string = string.replace(" | ||
+ | \\ | ||
**//SQL to create table tweets_info// | **//SQL to create table tweets_info// | ||
+ | \\ | ||
DROP TABLE IF EXISTS tweets_info; | DROP TABLE IF EXISTS tweets_info; | ||
+ | \\ | ||
CREATE TABLE tweets_info( \\ | CREATE TABLE tweets_info( \\ | ||
tweetCreated VARCHAR(50), | tweetCreated VARCHAR(50), | ||
Line 63: | Line 63: | ||
matchingRulesID BIGINT | matchingRulesID BIGINT | ||
); \\ | ); \\ | ||
+ | \\ | ||
psql cynthiak | psql cynthiak | ||
\copy tweets_info FROM '/ | \copy tweets_info FROM '/ |