Monthly Archives: August 2013

https://wiki.archlinux.org/index.php/Pacman_Rosetta

http://darthdeus.github.io/blog/2013/08/19/postgresql-basics-by-example/ To look at a stored procedure: Use this to find the procedure name: SELECT routine_schema As schema_name, routine_name As procedure_name FROM information_schema.routines; Then use this from the psql prompt to read the sql: SELECT pg_get_functiondef(( SELECT oid FROM pg_proc … Continue reading →

use dbname; update wp_options set option_value = http://www.domain.com where option_name = ‘siteurl’ and option_value = ‘http://www.olddomain.com’;

#Which command checks the user’s path: which iptables /sbin/iptables #Whereis command checks a list of standard Linux places whereis iptables iptables: /sbin/iptables /usr/share/man/man8/iptables.8.gz