In [1]:

    

%load_ext sql


    

In [2]:

    

%sql postgres://twg4_user:3axavey7=hakEyek@tw4-small.cnc4ebuyotg1.us-west-1.rds.amazonaws.com/twg4_db


    

    
Out[2]:





'Connected: twg4_user@twg4_db'

In [3]:

    

%sql select * from pg_tables


    

    




81 rows affected.






    
Out[3]:





    

        
schemaname
        
tablename
        
tableowner
        
tablespace
        
hasindexes
        
hasrules
        
hastriggers
        
rowsecurity
    
    

        
tw4_db
        
job_archive_2014
        
twg4_user
        
None
        
False
        
False
        
False
        
False
    
    

        
tw4_db
        
history
        
twg4_user
        
None
        
True
        
False
        
False
        
False
    
    

        
tw4_db
        
tweetphiladelphia
        
twg4_user
        
None
        
False
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_statistic
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_type
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
tw4_db
        
mention
        
twg4_user
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_authid
        
rdsadmin
        
pg_global
        
True
        
False
        
False
        
False
    
    

        
tw4_db
        
oauth
        
twg4_user
        
None
        
True
        
False
        
False
        
False
    
    

        
tw4_db
        
roles
        
twg4_user
        
None
        
False
        
False
        
False
        
False
    
    

        
tw4_db
        
job
        
twg4_user
        
None
        
True
        
False
        
False
        
False
    
    

        
tw4_db
        
jobupdate_save
        
twg4_user
        
None
        
False
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_user_mapping
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
tw4_db
        
MISSOURI
        
twg4_user
        
None
        
False
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_largeobject
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_attribute
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_proc
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_class
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_attrdef
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_constraint
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_inherits
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_index
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_operator
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_opfamily
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_opclass
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_am
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_amop
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_amproc
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_language
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_largeobject_metadata
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_aggregate
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_rewrite
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_trigger
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_event_trigger
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_description
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_cast
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_enum
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_namespace
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_conversion
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
tw4_db
        
tweetcompton
        
twg4_user
        
None
        
False
        
False
        
False
        
False
    
    

        
tw4_db
        
tweetmemphis
        
twg4_user
        
None
        
False
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_depend
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_db_role_setting
        
rdsadmin
        
pg_global
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_tablespace
        
rdsadmin
        
pg_global
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_pltemplate
        
rdsadmin
        
pg_global
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_auth_members
        
rdsadmin
        
pg_global
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_shdepend
        
rdsadmin
        
pg_global
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_shdescription
        
rdsadmin
        
pg_global
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_ts_config
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_ts_config_map
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_ts_dict
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_ts_parser
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_ts_template
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_extension
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_foreign_data_wrapper
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_foreign_server
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_foreign_table
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_policy
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_replication_origin
        
rdsadmin
        
pg_global
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_default_acl
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_seclabel
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_shseclabel
        
rdsadmin
        
pg_global
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_collation
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_range
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_transform
        
rdsadmin
        
None
        
True
        
False
        
False
        
False
    
    

        
pg_catalog
        
pg_database
        
rdsadmin
        
pg_global
        
True
        
False
        
False
        
False
    
    

        
tw4_db
        
tweet
        
twg4_user
        
None
        
True
        
False
        
False
        
False
    
    

        
tw4_db
        
tweetalabama
        
twg4_user
        
None
        
False
        
False
        
False
        
False
    
    

        
tw4_db
        
update_status
        
twg4_user
        
None
        
False
        
False
        
False
        
False
    
    

        
tw4_db
        
url
        
twg4_user
        
None
        
True
        
False
        
False
        
False
    
    

        
tw4_db
        
tweetchicago
        
twg4_user
        
None
        
False
        
False
        
False
        
False
    
    

        
information_schema
        
sql_features
        
rdsadmin
        
None
        
False
        
False
        
False
        
False
    
    

        
information_schema
        
sql_implementation_info
        
rdsadmin
        
None
        
False
        
False
        
False
        
False
    
    

        
tw4_db
        
UKRAINE
        
twg4_user
        
None
        
False
        
False
        
False
        
False
    
    

        
information_schema
        
sql_languages
        
rdsadmin
        
None
        
False
        
False
        
False
        
False
    
    

        
information_schema
        
sql_packages
        
rdsadmin
        
None
        
False
        
False
        
False
        
False
    
    

        
information_schema
        
sql_parts
        
rdsadmin
        
None
        
False
        
False
        
False
        
False
    
    

        
information_schema
        
sql_sizing
        
rdsadmin
        
None
        
False
        
False
        
False
        
False
    
    

        
information_schema
        
sql_sizing_profiles
        
rdsadmin
        
None
        
False
        
False
        
False
        
False
    
    

        
tw4_db
        
tweetneworleans
        
twg4_user
        
None
        
False
        
False
        
False
        
False
    
    

        
tw4_db
        
tweetnepal
        
twg4_user
        
None
        
False
        
False
        
False
        
False
    
    

        
tw4_db
        
hashtag
        
twg4_user
        
None
        
True
        
False
        
False
        
False
    

In [4]:

    

%sql select relname from pg_class where relkind='r' and relname !~ '^(pg_|sql_)'


    

    




20 rows affected.






    
Out[4]:





    

        
relname
    
    

        
job_archive_2014
    
    

        
history
    
    

        
tweetphiladelphia
    
    

        
mention
    
    

        
oauth
    
    

        
roles
    
    

        
job
    
    

        
jobupdate_save
    
    

        
MISSOURI
    
    

        
tweetcompton
    
    

        
tweetmemphis
    
    

        
tweet
    
    

        
tweetalabama
    
    

        
update_status
    
    

        
url
    
    

        
tweetchicago
    
    

        
UKRAINE
    
    

        
tweetneworleans
    
    

        
tweetnepal
    
    

        
hashtag
    

In [5]:

    

%sql SET search_path TO tw4_db


    

    




Done.






    
Out[5]:





[]

In [6]:

    

%sql SELECT * FROM roles


    

    




0 rows affected.






    
Out[6]:





    

        
role_id
        
name
    

In [8]:

    

%sql SELECT text,from_user_name FROM tweet WHERE from_user = '589716682'


    

    




1 rows affected.






    
Out[8]:





    

        
text
        
from_user_name
    
    

        
I have lost so many lip gloss/ chap sticks over the years 
        
jessica_belle_
    

In [ ]: