Categories
- Data Science (108)
- Hacking (27)
- Cryptology (1)
- Reverse Engineering (4)
- Security (23)
- Math & Statistics (27)
- Econometrics (4)
- Machine Learning (11)
- Math (3)
- Statistics (18)
- Substantive Expertise (56)
- Big Data (31)
- Computer History (3)
- Design (UI, UX, etc) (5)
- Economics (13)
- Game Theory (1)
- GIS (1)
- Text Mining (3)
- Hacking (27)
- Editorial (6)
- Programming (178)
- Quick Tips (32)
- Sys-Admin (26)
- Uncategorized (1)
Quick Tip: Show Postgres/pSQL Tables in Postgres OR R in 1 Line
September 15th, 2014 | Author: jdm
Outside of R:
\dt
In R:
dt <- dbGetQuery(con1, “SELECT * FROM pg_catalog.pg_tables”)
Tags
1-line anon bash big-data big-data-viz C data-science econ econometrics editorial hacking HBase hive hql infosec java javascript linux lists machine-learning macro micro mssql MySQL nosql padb passwords postgres programming python quick-tip r ruby SAS sec security sql statistics stats sys-admin tsql usability useable-sec web-design windows
Stackoverflow Solutions
Total Answered: 656