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
<span class="label" ng-class="{'possibleValue1' : 'class1', 'possibleValue2' : 'class2', 'possibleValue3' : 'class3'}[object.value]" ng-bind-html='object.value'></span> |
<?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"), |
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 |
-- 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 |
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
<script> | |
var form = $('#attach-local-doc-form'); | |
/* | |
* Note that variable `data` will not show anything due to hidden properties. | |
* It's purpose is to be passed to the server for parsing. | |
*/ | |
var data = new FormData(form.get(0)); | |
var fileNames = documentData.getAll("userfile").map(function (file) { | |
return file.name; | |
}); |
var fileList = $("#comment-attachment").get(0).files; |