dokuwiki postgres https://trust-box.at/dokuwiki/ 2026-04-19T22:20:18+0200 dokuwiki https://trust-box.at/dokuwiki/ https://trust-box.at/dokuwiki/lib/tpl/dokuwiki/images/favicon.ico text/html 2014-09-10T21:22:55+0200 Anonymous (anonymous@undisclosed.example.com) postgres:beispieldatenbank https://trust-box.at/dokuwiki/doku.php?id=postgres:beispieldatenbank&rev=1410376975&do=diff world.sql text/html 2014-09-10T21:22:55+0200 Anonymous (anonymous@undisclosed.example.com) postgres:copy_command https://trust-box.at/dokuwiki/doku.php?id=postgres:copy_command&rev=1410376975&do=diff europa.csv world=# create table membership_raw (State text, GNI text, wage text, UN text, CoE text, OSCE text, EU text, EEA text, CU text, Schengen text, euro text, OECD text, WTO text, ESA text, NATO text, ICC text, VWP text); world=# \encoding latin1 world=# copy membership_raw from '/home/mh/world/europa.csv' delimiter ';'; world=# select count(code2) from countries where name in (select state from membership_raw); count ----- world=# create table countries_x_organisations (code charac… text/html 2014-09-10T21:22:55+0200 Anonymous (anonymous@undisclosed.example.com) postgres:datumsberechnungen https://trust-box.at/dokuwiki/doku.php?id=postgres:datumsberechnungen&rev=1410376975&do=diff select age(to_date('20120601', 'yyyymmdd'), current_date); text/html 2014-09-10T21:22:55+0200 Anonymous (anonymous@undisclosed.example.com) postgres:enum https://trust-box.at/dokuwiki/doku.php?id=postgres:enum&rev=1410376975&do=diff create type governmentform_enum as enum ( $$Monarchy$$, $$Socialistic Republic$$, $$Federal Republic$$, $$Overseas Department of France$$, $$Constitutional Monarchy$$, $$Special Administrative Region of China$$, $$Part of Denmark$$, $$Administrated by the UN$$, $$Republic$$, $$Islamic Republic$$, $$US Territory$$, $$Monarchy (Emirate)$$, $$Dependent Territory of the US$$, $$Co-administrated$$, $$Dependent Territory of the UK$$, $$Constitutional Monarchy, Federation$$, $$Territory of Australia$$,… text/html 2014-09-10T21:22:55+0200 Anonymous (anonymous@undisclosed.example.com) postgres:europa.csv https://trust-box.at/dokuwiki/doku.php?id=postgres:europa.csv&rev=1410376975&do=diff Albania;3,950;332;UN;CoE;OSCE;Applied;;EUFTA;EU visa-free;ALL;;WTO;;NATO;ICC;39.6 Andorra;41,130;;UN;CoE;OSCE;x;;EUCU;EU visa-free;€;;obs;;;ICC;VWP Armenia;3,100;;UN;CoE;OSCE;EaP;obs;CISFTA;CIS visa-free;AMD;;WTO;;CSTO;sign;48.9 Austria;46,850;2,758;UN;CoE;OSCE;EU;EEA;EUCU;Schengen;€;OECD;WTO;ESA;PfP;ICC;VWP Azerbaijan;4,840;;UN;CoE;OSCE;EaP;;CISFTA;CIS visa-free;AZN;GUAM;obs;;PfP;;14 Belarus;5,540;528;UN;obs;OSCE;BRU;EAEC;CUBKR;CIS visa-free;BYR;;obs;BSA;CSTO;;15.5 Belgium;45,310;2,464;UN;CoE;O… text/html 2014-09-10T21:22:55+0200 Anonymous (anonymous@undisclosed.example.com) postgres:import_aus_file https://trust-box.at/dokuwiki/doku.php?id=postgres:import_aus_file&rev=1410376975&do=diff immer forward / da aus Unix Welt world=# \i c:/pfad/zu/world.sql text/html 2014-09-10T21:22:55+0200 Anonymous (anonymous@undisclosed.example.com) postgres:postgresql-administration https://trust-box.at/dokuwiki/doku.php?id=postgres:postgresql-administration&rev=1410376975&do=diff import aus file select attname, most_common_vals from pg_stats where tablename = 'xxx'; create user dd password 'bla' grant all on database doctrine to dd; space usage text/html 2014-09-10T21:22:55+0200 Anonymous (anonymous@undisclosed.example.com) postgres:postgresql-sql https://trust-box.at/dokuwiki/doku.php?id=postgres:postgresql-sql&rev=1410376975&do=diff Beispieldatenbank copy command enum