_____ infoCopter.com _____

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


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.

Advanced Features

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)
© 1998-2004 infoCopter