Now located at https://github.com/JeffPaine/beautiful_idiomatic_python.
Github gists don't support Pull Requests or any notifications, which made it impossible for me to maintain this (surprisingly popular) gist with fixes, respond to comments and so on. In the interest of maintaining the quality of this resource for others, I've moved it to a proper repo. Cheers!
| Ort;Zusatz;Plz;Vorwahl;Bundesland | |
| Aach;b Trier;54298;0651;Rheinland-Pfalz | |
| Aach;, Hegau;78267;07774;Baden-Württemberg | |
| Aachen;;52062;0241;Nordrhein-Westfalen | |
| Aachen;;52064;0241;Nordrhein-Westfalen | |
| Aachen;;52066;0241;Nordrhein-Westfalen | |
| Aachen;;52068;0241;Nordrhein-Westfalen | |
| Aachen;;52070;0241;Nordrhein-Westfalen | |
| Aachen;;52072;0241;Nordrhein-Westfalen | |
| Aachen;;52074;0241;Nordrhein-Westfalen |
| -- show running queries (pre 9.2) | |
| SELECT procpid, age(clock_timestamp(), query_start), usename, current_query | |
| FROM pg_stat_activity | |
| WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' | |
| ORDER BY query_start desc; | |
| -- show running queries (9.2) | |
| SELECT pid, age(clock_timestamp(), query_start), usename, query | |
| FROM pg_stat_activity | |
| WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' |
