Magic words:
psql -U postgres
If run with -E
flag, it will describe the underlaying queries of the \
commands (cool for learning!).
Most \d
commands support additional param of __schema__.name__
and accept wildcards like *.*
# Enable this for template generation | |
Alias /munin /var/www/munin | |
# Enable this for cgi-based templates | |
#Alias /munin-cgi/static /var/cache/munin/www/static | |
#ScriptAlias /munin-cgi /usr/lib/munin/cgi/munin-cgi-html | |
#<Location /munin-cgi> | |
# Order allow,deny | |
# Allow from localhost 127.0.0.0/8 ::1 | |
# AuthUserFile /etc/munin/munin-htpasswd |
import SwiftUI | |
struct Theme: Hashable { | |
var colorPrimary: Color = Color.primary | |
var name: String? = nil | |
var publicName: String = "System" | |
} | |
var themes: [Theme] = [ | |
Theme(colorPrimary: Color.primary, name: nil, publicName: "System"), |
// npm i -g gulp | |
// npm i gulp gulp-uglify gulp-rename gulp-concat gulp-header gulp-minify-css gulp-watch | |
var gulp = require('gulp'), | |
uglify = require('gulp-uglify'), | |
rename = require('gulp-rename'), | |
concat = require('gulp-concat'), | |
header = require('gulp-header'), | |
pkg = require('./package.json'), | |
minifyCSS = require('gulp-minify-css'), | |
watch = require('gulp-watch'); |
on openTerminal(location, remoteHost, serverPort) | |
tell application "System Events" | |
-- some versions might identify as "iTerm2" instead of "iTerm" | |
set isRunning to (exists (processes where name is "iTerm")) or (exists (processes where name is "iTerm2")) | |
end tell | |
tell application "iTerm" | |
activate | |
set targetTab to "" |
" sudo add-apt-repository ppa:jonathonf/vim && sudo apt-get update && apt upgrade -y | |
" Install Vundle | |
" Install this .vimrc | |
" :PluginInstall | |
set nocompatible " be iMproved, required | |
filetype off " required | |
" set the runtime path to include Vundle and initialize | |
set rtp+=~/.vim/bundle/Vundle.vim |
install PostgreSQL 9 in Mac OSX via Homebrew | |
Mac OS X Snow Leopard | |
System Version: Mac OS X 10.6.5 | |
Kernel Version: Darwin 10.5.0 | |
Install notes for PostgreSQL 9.0.1 install using Homebrew: | |
sh-3.2# brew install postgresql |
# This file is zentralized to be a Turorial. | |
# I'm not sure about the full selfish-work. | |
# We will isntall OpenSSL,NginX,PostgreSQL. | |
# Than we will isntall Ajenti. | |
# Than you must configurate Ajenti to not use SSL (we will changethis later back) | |
# Followed we install Wordpress and you will have to install some plugins for PSQL and Nginx. | |
# Ready to press words! | |
# ---------- | |
#remove instalaltion hardware ofthe sources.list | |
nano /etc/apt/sources.list |
# Stop all containers | |
docker stop $(docker ps -a -q) | |
# Delete all containers | |
docker rm $(docker ps -a -q) | |
# Delete all images |
<?php | |
function getPrice($productId) { | |
$result = ''; | |
$PRICE_TYPE_ID = 1; # just example, see in admin panel | |
$rsPrices = CPrice::GetList(array(), array('PRODUCT_ID' => $productId, 'CATALOG_GROUP_ID' => $PRICE_TYPE_ID)); | |
if ($arPrice = $rsPrices->Fetch()) | |
{ | |
$result = CurrencyFormat($arPrice["PRICE"], $arPrice["CURRENCY"]); | |
} | |
return $result; |