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
The aim of this guide is to create the basic idea of how to set up a very basic hook. Once you've read through this guide, please read through the Git Hooks Documentation. But first...
In very basic terms, it's a thing that "fires off custom scripts when certain important actions occur". For example, each time we make a commit, a git hook will run some code that does some cool stuff automatically. Because sometimes we want stuff to happen automatically and Git Hooks help us do that!
Oh, sure. Imagine a conversation between you and your supervisor that goes like this:
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
select | |
pc_games.title, | |
to_char(pc_games.release_date, 'YYYY-MM-DD') as release_date | |
array_to_string(array_agg(avid_fans.firstname || ' ' || avid_fans.surname), ', ', null) as fans | |
from | |
schema_A.pc_games as pc_games | |
inner join schema_A.avid_fans as avid_fans on (pc_games.id = avid_fans.fk_pc_game_id) | |
where | |
pc_games.release_date > '2004-12-31' | |
group by |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<span class="label" ng-class="{'possibleValue1' : 'class1', 'possibleValue2' : 'class2', 'possibleValue3' : 'class3'}[object.value]" ng-bind-html='object.value'></span> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- To view all values in the enum: | |
SELECT unnest(enum_range(NULL::schema.enum_name)); | |
-- To add a value to the enum: | |
ALTER TYPE schema.enum_name ADD VALUE 'new_enum_value'; | |
-- For more operation see: https://www.postgresql.org/docs/9.1/static/sql-altertype.html |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
$results = array(); | |
# The "$selected_functions" array will be constructed on the client side and posted to the PHP controller function. | |
# Populate the "$selected_functions" array based on user interaction with the UI. | |
$selected_functions = array( | |
"function_1" => array("parameter_1_1", "parameter_1_2", "parameter_1_3"), | |
"function_2" => array("parameter_2_1"), |