Open terminal.
Connect to psql:
psql -p 5433
I find it easier to delete and recreate the DB to which you want to import. So ensure the databse you want to delete is listed:
\l
| SELECT todo_lists.id AS id, | |
| todo_lists.name, | |
| jsonb_agg(to_jsonb(todo_items) - 'todo_list_id') AS items | |
| FROM todo_lists | |
| LEFT JOIN todo_items ON todo_items.todo_list_id = todo_lists.id | |
| GROUP BY todo_lists.id; |
| <?php | |
| /** | |
| * Plugin Name: WooCommerce Settings Tab Demo | |
| * Plugin URI: https://gist.github.com/BFTrick/b5e3afa6f4f83ba2e54a | |
| * Description: A plugin demonstrating how to add a WooCommerce settings tab. | |
| * Author: Patrick Rauland | |
| * Author URI: http://speakinginbytes.com/ | |
| * Version: 1.0 | |
| * | |
| * This program is free software: you can redistribute it and/or modify |
| // Place this with the other middleware inclusion in routes/index.js | |
| keystone.pre('admin', middleware.enforcePermissions); |
Open terminal.
Connect to psql:
psql -p 5433
I find it easier to delete and recreate the DB to which you want to import. So ensure the databse you want to delete is listed:
\l
| <?php | |
| // android store | |
| if (preg_match('#android#i', $_SERVER ['HTTP_USER_AGENT'])) { | |
| header('Location: market://details?id=com.google.android.apps.maps'); | |
| exit; | |
| } | |
| // ios | |
| if (preg_match('#(iPad|iPhone|iPod)#i', $_SERVER ['HTTP_USER_AGENT'])) { |
| #! /bin/bash | |
| # Replace "/path/to/gsutil/" with the path of your gsutil installation. | |
| PATH="$PATH":/path/to/gsutil/ | |
| # Replace "/home/username/" with the path of your home directory in Linux/Mac. | |
| # The ".boto" file contains the settings that helps you connect to Google Cloud Storage. | |
| export BOTO_CONFIG="/home/username/.boto" | |
| # A simple gsutil command that returns a list of files/folders in your bucket. |
| function atz_split_content_at_more(){ | |
| // Split the content | |
| $content_parts = preg_split('/<span id="more-\d+"><\/span>/i', get_the_content()); | |
| // Grab first part of content and apply filters | |
| $result['intro'] = apply_filters('the_content', array_shift($content_parts));; | |
| // Content has a more part? | |
| if(!empty($content_parts)): | |
| $result['more'] = apply_filters('the_content', implode($content_parts)); |
| <?xml version="1.0" encoding="UTF-8"?> | |
| <!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd"> | |
| <plist version="1.0"> | |
| <dict> | |
| <key>name</key> | |
| <string>Xcode-ish</string> | |
| <key>settings</key> | |
| <array> | |
| <dict> | |
| <key>settings</key> |