Free Stuff

About IC

PostgreSQL OpenSource Database PostgreSQL has won the 2003 Linux Journal Editors' Choice Award for the best DBMS! See also PostgreSQL.org

Getting Started and Fundamentals

(Deutsch) Eine kurze Geschichte über die PostgreSQL:

PostgreSQL ist die weltweit fortschrittlichste OpenSource Datenbanksoftware. Die PostgreSQL Software selbst hat ihre Anfänge 1986 in der Berkeley Universität, Kalifornien. Seither hat sich das Forschungsprojekt zum heutigen global verteilten Datenbanksystem weiter entwickelt.

• Frequently Asked Questions (FAQ) for PostgreSQL
  
  
• Was unterscheidet ein PostgreSQL- von einem MySQL-Datenbank-System?
  
  
• Tips
  
  
• Everything about CREATE
  
  
• Data Types
  
  
• pgAdmin II
  A comprehensive PostgreSQL database design and management system for Windows 95/98/ME/NT/2000/XP and freely available.
  
  
• Data Types
  
  
• Date & Time
  
  
• Create Table Online Tool
  
  
• Related News Groups
  
  
• Unix style start / stop script
  
  

Advanced Features

• Foreign Keys
  
  
• Apache Module mod_auth_pgsql
  PostgreSQL Authentication
  
  
• Removing a Column, Renaming a Table...
  
  
• Foreign Keys
  Tutorial - Constraints
  
  
• PostgreSQL Database Replication
  
  
• SQL
  Joins
  
  
• System Columns
  
  
• Alternative Locations
  It is possible to create a database in a location other than the default location for the installation
  
  

Useful Stuff & Quickies

• List all available databases on a database host:
  $ echo "SELECT datname FROM pg_database ORDER BY datname;" | psql -d template1
  
  
• Dump complete database into a single file:
  pg_dump -f "foo.dump" <DBNAME>

Related Links

1. PHPPgEdit (Software)
   http://www.phppgedit.org/
   The port of the GNU PHPMyEdit project on the OpenSource DBMS Postgresql. PHPPgEdit and PHPMyEdit are instant table editors in PHP.
   This port is crap, Sorry. phpPgAdmin is out-of-the box working meanwhile. (2007-10-04 15:30)
   
   
2. PostgreSQL (Reference)
   http://www.postgresql.org/docs/8.1/interactive/plpgsql.html
   PL/pgSQL - SQL Procedural Language. (2007-08-08 11:24)
   
   
3. PostgreSQL Know-how (Reference)
   http://www.postgresql.org/files/documentation/books/pghandbuch/html/sql-altertable.html
   ALTER TABLE ...
   See also: know-how/postgresql/alter-table (2007-03-07 09:32)
   
   
4. PostgreSQL Know-how (Reference)
   http://www.postgresql.org/docs/current/static/sql-createtrigger.html
   CREATE TRIGGER.
   
   See also: postgresql.org/.../triggers.html (2007-02-08 17:21)
   
   
5. PostgreSQL Know-how (Reference)
   http://www.postgresql.org/docs/current/static/functions-datetime.html
   Date and time functions (2007-01-05 10:21)
   
   
6. PostgreSQL.org/docs/7/static/trouble18048.htm (Reference)
   http://www.postgresql.org/docs/7/static/trouble18048.htm
   Debugging Messages. PostgreSQL Troubleshooting (2005-03-25 02:48)
   
   
7. Google.ch/search?hl..de..q..postgresql..faq... (Reference)
   http://www.google.ch/search?hl=de&q=postgresql+faq+site%3Apostgresql.org
   PostgreSQL FAQ (2005-03-12 21:56)
   
   
8. postgresql/user-manag.html (Reference)
   http://primus.infocopter.com/postgresql/user-manag.html
   Database Users and Privileges (2004-12-01 16:25)
   
   
9. postgresql/client-authentication.html (Reference)
   http://primus.infocopter.com/postgresql/client-authentication.html
   PostgreSQL Client Authentication and the pg_hba.conf file (2004-12-01 16:21)
   
   
10. Eskimo.com/support/PostgreSQL/tutorial/c0102.htm (Reference)
    http://www.eskimo.com/support/PostgreSQL/tutorial/c0102.htm
    Introduction to PostgreSQL (2004-10-05 16:45)
    
    
11. LinuxJournal.com/article.php?sid=2245 (Reference)
    http://www.linuxjournal.com/article.php?sid=2245
    Short introduction to PostgreSQL (2004-10-05 16:39)
    
    
12. know-how/postgresql/postgres-vs-others.html (Reference)
    http://www.infocopter.com/know-how/postgresql/postgres-vs-others.html
    Was unterscheidet ein PostgreSQL- von einem MySQL-Datenbank-System? (2004-06-20 15:46)
    
    
13. pgsql.com/download (Software)
    http://www.pgsql.com/download/
    Conversion tool for migrating from MySQL to PostgreSQL by PostgreSQL Inc. (mysql2pgsql 1.0) (2004-06-20 15:41)
    
    
14. devx.com/dbzone/Article/... (Reference)
    http://www.devx.com/dbzone/Article/20743
    PostgreSQL vs. MySQL vs. Commercial Databases (2004-06-15 13:13)
    
    
15. TechDocs.PostgreSQL.org (Reference)
    http://techdocs.postgresql.org/
    PostgreSQL Technical Documentation (2004-05-06 10:13)
    
    
16. siag.nu/libsdb (Software)
    http://siag.nu/libsdb/
    libsdb, the simple database library, which provides a way to support multiple database management systems in an application with negligeable overhead, in terms of code as well as system resources. It is mainly intended for use on Unix, but the ODBC driver works on Windows as well. (2004-03-04 01:36)
    
    
17. PostgreSQL.org/docs/pg_handbuch/.../history.html (Reference)
    http://www.postgresql.org/docs/pg_handbuch/html/history.html
    Die kurze Geschichte von PostgreSQL. Das POSTGRES-Projekt in Berkeley (2004-02-27 01:39)
    
    
18. GBorg.PostgreSQL.org/project/pgreplication/... (CInternet:Webmaster)
    http://gborg.postgresql.org/project/pgreplication/projdisplay.php
    The pgreplication Project -- PostgreSQL Replication from the Information and Communication Systems Group, ETH in Zurich, Switzerland (2003-07-08 23:27)
    
    
19. LAMPS.efactory.de/lamps-2-0... (CInternet:Webmaster)
    http://lamps.efactory.de/lamps-2-0.shtml
    LAMPS Tutorial. Kompilieren, Installieren und
    Konfigurieren eines LAMPS Servers. Apache 2.0, Mod_Perl,
    PHP, Mod_SSL, MySQL, PostgreSQL und PDFLib in wenigen
    Schritten und anhand von Beispielen (2003-01-24 15:56)
    
    
20. Postgresql.org/users-lounge/events.html (Event)
    http://www.ca.postgresql.org/users-lounge/events.html
    Upcoming PostgreSQL Events (2001-12-10 12:26)
    
    
21. postgresql.org (CInternet)
    http://www.postgresql.org
    Official WebSite of the most popular Open Source Database (1999-08-02 9:45)