PostgreSQL notes

SQL

CREATE DATABASE database_name;

CREATE SCHEMA schema_name;

CREATE TABLE films (
    code        char(5) CONSTRAINT firstkey PRIMARY KEY,
    title       varchar(40) NOT NULL,
    did         integer NOT NULL,
    date_prod   date,
    kind        varchar(10),
    len         interval hour to minute
);

CREATE TABLE distributors (
     did    integer PRIMARY KEY DEFAULT nextval('serial'),
     name   varchar(40) NOT NULL CHECK (name <> '')
);

CREATE TABLE array_int (
    vector  int[][]
);

SELECT * FROM information_schema.tables 
WHERE table_schema = 'public'

ALTER TABLE

Utilities

WinStuff

Browsers
Google Chrome - Site (http://www.google.com/chrome/)
Mozilla Firefox - Site (https://www.mozilla.org/en-US/firefox/)

Archive & Compress
7-Zip - Site (http://www.7-zip.org/)
WinRAR - Site (http://www.rarlab.com/)

Antivirus
ClamWin - Site (http://www.clamwin.com/)
ClamSentinel - Site (http://clamsentinel.sourceforge.net/)

Media
JPEGView - Site (http://sourceforge.net/projects/jpegview/)
VLC - Site (http://www.videolan.org/vlc/index.html)
InkScape - Site (https://inkscape.org/en/)
Blender - Site (http://www.blender.org/)

Virtual
WinCDEmu - Site (http://wincdemu.sysprogs.org/)

Torrent
Tixati - Site (http://www.tixati.com/)

Administrative
PuTTy - Site (http://www.chiark.greenend.org.uk/~sgtatham/putty/)
WinSCP - Site (http://winscp.net/eng/index.php)
BabyFTPS - Site (http://www.pablosoftwaresolutions.com/html/baby_ftp_server.html)
TFTPD - Site (http://tftpd32.jounin.net/)
Z-WAMP - Site (http://zwamp.sourceforge.net/)

Design
FreeCAD - Site (http://www.freecadweb.org/)
https://www.gnu.org/software/octave/



PHP - Site (http://php.net/)
MySQL - Site (http://www.mysql.com/)
Python - Site (https://www.python.org/)
Notepad++ - Site (http://notepad-plus-plus.org/)
TeXnicCenter - Site (http://www.texniccenter.org/)
MultiBit - Site (https://multibit.org/)
OpenOffice - Site (https://www.openoffice.org/)

SumatraPDF - Site (http://www.sumatrapdfreader.org/free-pdf-reader.html)

Tox - Site (http://tox.im/)

Dev
MSVS - Site (http://www.visualstudio.com/)
NetBeans - Site (https://netbeans.org/)
OpenTK - C# OpenGL
NpgSQL2 - C# PostgreSQL


Cryptography
GPG - Site (https://www.gnupg.org/)

Anonymity
I2P - Site (https://geti2p.net/en/)
TOR - Site (https://www.torproject.org/)
Freenet - Site (https://freenetproject.org/)


Some stuff
ssh
postresql
vsftpd
xfce
apache, php, python, mysql, ravendb, mongodb, mariadb
svn
git
postfix, dovecot
wireshark