FATAL ERROR
SELECT id, path, name, description, address, point(lon,lat) AS coordinates FROM lovin_dir WHERE path ~ 'top.*{2}.wichita.venue.the_vertical_violet.gentleman_auction_house_w._bald_eagle_witch's_hat_and_sun__168209.liquid.sams_place.kirbys_beer_store' ORDER BY name
ERROR: syntax error at or near "s_hat_and_sun__168209" LINE 4: ...iolet.gentleman_auction_house_w._bald_eagle_witch's_hat_and_... ^

FATAL ERROR
SELECT id, name, path, description FROM lovin_dir WHERE path ~ ''
ERROR: syntax error DETAIL: Unexpected end of line.

Alumni Auditorium Best Western Wichita North Hotel and Suites Botanica the Wichita Gardens Caffe Moderne Central Christian College Century 2 Convention Center Cotiliion Ballroom Cotillion Downtown Wichita Eagles Lodge North Genesis Health Club Heroes Kirbys Beer Store Liquid Naftzger Park Old Town District Orpheum Theatre Sam's Place Tallgrass Country Club The Anchor Drinking Establishment The Artichoke The Cotillion The Cotillion Ballroom The Iron Horse Concert Hall The Vertical Violet Towne East Square Mall Wichita Art Museum