ebouchut + extract   12

Export Postgres Query to CSV | Jon Saints
"
First, connect to the remote database server:

psql -h REMOTE_SERVER_ADDRESS -U DB_USER -W

Then, export a query to CSV… \copy makes the file go to your local machine rather than the database server file system

\copy (select * from my_table) TO '~/Downloads/my_table.csv' CSV HEADER
"
postgres  CSV  export  select  data  extract  create  psql  sql  query  request  copy  table  row 
10 weeks ago by ebouchut
Data Science at the Command Line
This is the website for Data Science at the Command Line, published by O’Reilly October 2014 First Edition. This hands-on guide demonstrates how the flexibility of the command line can help you become a more efficient and productive data scientist. You’ll learn how to combine small, yet powerful, command-line tools to quickly obtain, scrub, explore, and model your data.
book  data  datascience  command  CLI  linux  shell  machine  learning  science  extract  parse  massage  tools 
january 2018 by ebouchut
linkedin/URL-Detector: A Java library to detect and normalize URLs in text
"The url detector is a library created by the Linkedin Security Team to detect and extract urls in a long piece of text."
URL  detect  parse  extract  find  search  text  locate  java 
july 2016 by ebouchut
Free Online Url Parser - Query String Splitter - FreeFormatter.com
"[...] parse a URL into its individual components, i.e scheme, protocol, username, password, hostname, port, domain, subdomain, tld, path, query string, hash, etc. It also splits the query string into a human readable format and takes of decoding the parameters. "
URL  query  parameter  split  extract  token  online  toolbag  parse  tokenize 
april 2015 by ebouchut

Copy this bookmark:



description:


tags: