iC Home > Know-how > Databases (DBMS) > PostgreSQL

Know-how 3.1 PostgreSQL		05.01.2009
← 3 Databases (DBMS)	[  up  ] - [ Know-how A - Z ] - [ top ]	3.2 MySQL →

---

X X X

1	Getting Started and Fundamentals
	1.1	PostgreSQL vs. Others
		1.1.1    PostgreSQL vs. MySQL
	1.2	Starting and Stopping
2	Reference
	2.1	Create Table
		2.1.1    Auto Counter
	2.2	Alter Table
	2.3	SELECT examples
	2.4	Data Types
	2.5	Date & Time
	2.6	Tips, Useful Stuff & Quickies
3	Authentication / Authorization
4	PostgreSQL Interfaces
	4.1	Perl Interface
5	Advanced Features
	5.1	Database Replication
	5.2	Basic Authorization
	5.3	Debugging PostgreSQL
	5.4	Backup & Restore
	5.5	PostgreSQL Geek Problems
6	Postgres Tools
	6.1	DBI Coder
	6.2	Create Table Online Tool
7	Related Links
8	Logos

---

• Häufig gestellte Fragen (FAQ) zu PostgreSQL - Reference CInternet:Webmaster
  Deutsche Übersetzung von Ian Barwick.
  sql-info.de/de/postgresql/FAQ_german.html
  
  
• PHPPgEdit - Software CInternet:Webmaster
  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.
  phppgedit.org/
  
  
• PostgreSQL - Reference CInternet:Webmaster
  PL/pgSQL - SQL Procedural Language.
  postgresql.org/docs/8.1/interactive/plpgsql.html
  
  
• PostgreSQL Know-how - Reference
  ALTER TABLE ...
  See also: know-how/postgresql/alter-table
  postgresql.org/files/documentation/books/pghandbuch/html/sql-altertable.html
  
  
• PostgreSQL Know-how - Reference
  CREATE TRIGGER.
  
  See also: postgresql.org/.../triggers.html
  postgresql.org/docs/current/static/sql-createtrigger.html
  
  
• PostgreSQL Know-how - Reference
  Date and time functions
  postgresql.org/docs/current/static/functions-datetime.html
  
  
• Hostmonster.com: Hosting Features - CInternet:Webmaster Services
  Hosting, ssh, databases
  hostmonster.com/hosting-features.htm
  
  
• PostgreSQL.org/docs/7/static/trouble18048.htm - Reference
  Debugging Messages. PostgreSQL Troubleshooting
  postgresql.org/docs/7/static/trouble18048.htm
  
  
• Google.ch/search?hl..de..q..postgresql..faq... - Reference
  PostgreSQL FAQ
  google.ch/search?hl=de&q=postgresql+faq+site%3Apostgresql.org
  
  
• postgresql/user-manag.html - Reference
  Database Users and Privileges
  primus.infocopter.com/postgresql/user-manag.html
  
  
• postgresql/client-authentication.html - Reference
  PostgreSQL Client Authentication and the pg_hba.conf file
  primus.infocopter.com/postgresql/client-authentication.html
  
  
• Eskimo.com/support/PostgreSQL/tutorial/c0102.htm - Reference
  Introduction to PostgreSQL
  eskimo.com/support/PostgreSQL/tutorial/c0102.htm
  
  
• LinuxJournal.com/article.php?sid=2245 - Reference
  Short introduction to PostgreSQL
  linuxjournal.com/article.php?sid=2245
  
  
• know-how/postgresql/postgres-vs-others.html - Reference
  Was unterscheidet ein PostgreSQL- von einem MySQL-Datenbank-System?
  infocopter.com/know-how/postgresql/postgres-vs-others.html
  
  
• pgsql.com/download - Software Reference
  Conversion tool for migrating from MySQL to PostgreSQL by PostgreSQL Inc. (mysql2pgsql 1.0)
  pgsql.com/download/
  
  
• pgadmin.org - Software
  pgAdmin III is a powerful administration and development platform for the PostgreSQL database, free for any use. The application is running under GNU/Linux, FreeBSD and Windows 2000/XP
  pgadmin.org/
  
  
• devx.com/dbzone/Article/... - Reference
  PostgreSQL vs. MySQL vs. Commercial Databases
  devx.com/dbzone/Article/20743
  
  
• everysoft.com/auction - Auction Software
  EveryAuctionDB was programmed from the ground up to be professional, reliable, and secure. It can handle virtually thousands of online transactions with absolutely no sign of slowdown. It is limited only by the system and database it is run on. Currently it has built-in support for PostgreSQL, MySQL, and Microsoft Access (ODBC). It should work with any other DBI module available for Perl (Microsoft SQL Server, Oracle, etc.) with few modifications
  everysoft.com/auction/
  
  
• TechDocs.PostgreSQL.org - Reference Software
  PostgreSQL Technical Documentation
  techdocs.postgresql.org/
  
  
• siag.nu/libsdb - Software Reference
  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.
  siag.nu/libsdb/
  
  
• PostgreSQL.org/docs/pg_handbuch/.../history.html - Reference
  Die kurze Geschichte von PostgreSQL. Das POSTGRES-Projekt in Berkeley
  postgresql.org/docs/pg_handbuch/html/history.html
  
  
• GBorg.PostgreSQL.org/project/pgreplication/... - CInternet:Webmaster Reference
  The pgreplication Project -- PostgreSQL Replication from the Information and Communication Systems Group, ETH in Zurich, Switzerland
  gborg.postgresql.org/project/pgreplication/projdisplay.php
  
  
• DBBalancer.sourceforge.net/docs/... - CInternet:Webmaster
  A database replicator
  dbbalancer.sourceforge.net/docs/c15.htm
  
  
• Vergenet.net/linux/perdition - CInternet:Webmaster
  Perdition is a fully featured POP3 and IMAP4 proxy server. It is able to handle both SSL and non-SSL connections and redirect users to a real-server based on a database lookup. Perdition supports modular based database access. ODBC, MySQL, PostgreSQL, GDBM, POSIX Regular Expression and NIS modules ship with the distribution. The API for modules is open allowing abitary modules to be written to allow access to any data store.
  vergenet.net/linux/perdition/
  
  
• LAMPS.efactory.de/lamps-2-0... - CInternet:Webmaster Reference
  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
  lamps.efactory.de/lamps-2-0.shtml
  
  
• GiuseppeTanzilli.it/mod_auth_pgsql - CInternet:Webmaster
  Apache Module mod_auth_pgsql
  PostgreSQL Authentication
  giuseppetanzilli.it/mod_auth_pgsql/
  
  
• Postgresql.org/users-lounge/events.html - Event Reference
  Upcoming PostgreSQL Events
  ca.postgresql.org/users-lounge/events.html
  
  
• postgresql.org - CInternet Reference
  Official WebSite of the most popular Open Source Database
  postgresql.org
  
  

copyright by reto - created with mytexi