-- Firstly, remove PRIMARY KEY attribute of former PRIMARY KEY
ALTER TABLE <table_name> DROP CONSTRAINT <table_name>_pkey;-- Then change column name of your PRIMARY KEY and PRIMARY KEY candidates properly.
ALTER TABLE <table_name> RENAME COLUMN <primary_key_candidate> TO id;
(by @andrestaltz)
If you prefer to watch video tutorials with live-coding, then check out this series I recorded with the same contents as in this article: Egghead.io - Introduction to Reactive Programming.
This is a collection of information on PostgreSQL and PostGIS for what I tend to use most often.
| --- | |
| title: "Applying a function over rows of a data frame" | |
| author: "Winston Chang" | |
| output: html_document | |
| editor_options: | |
| chunk_output_type: console | |
| --- | |
| ```{r setup, include=FALSE} | |
| knitr::opts_chunk$set(collapse = TRUE, comment = "#>") |
| SELECT json_build_object( | |
| 'type', 'FeatureCollection', | |
| 'crs', json_build_object( | |
| 'type', 'name', | |
| 'properties', json_build_object( | |
| 'name', 'EPSG:4326' | |
| ) | |
| ), | |
| 'features', json_agg( | |
| json_build_object( |
macOS has ncurses version 5.7 which does not ship the terminfo description for tmux. There're two ways that can help you to solve this problem.
Instead of tmux-256color, use screen-256color which comes with system. Place this command into ~/.tmux.conf or ~/.config/tmux/tmux.conf(for version 3.1 and later):
| Seven different types of CSS attribute selectors | |
| // This attribute exists on the element | |
| [value] | |
| // This attribute has a specific value of cool | |
| [value='cool'] | |
| // This attribute value contains the word cool somewhere in it | |
| [value*='cool'] |
| <?php | |
| \Illuminate\Support\Str::macro('extremeSnake', function($value, $delimiter = '_') { | |
| $pattern = <<<'REGEXP' | |
| / | |
| (?<!^) # don't match the beginning of a string | |
| ( | |
| (?<=[^\p{Lu}])[\p{Lu}\p{M}]+(?=\p{M}?[^\p{Ll}]\p{M}?\p{L}) # string of upper-case (like an abbreviation) | |
| | (?<=\p{Lu}{2})[\p{Lu}\p{M}](?=\p{M}?\p{Ll}) # the final upper-case in a sequence | |
| | (?<=[^\p{Lu}])[\p{Lu}\p{M}](?=\p{M}?\p{Ll}) # first upper-case in a capitalized sequence |
Currently validated through Herd 1.9.1. Last Updated August 7th, 2024
There are a few options to get Herd/Reverb working with SSL & across your local network among other devices:
The biggest issue with Herd Pro is that you cannot use Reverb out of the box with a site that has SSL enabled. Here is the workaround for it all to play nicely together.
