Search 5,000,000+ questions and answers.

Frequently Asked Questions

What is the copyright of PostgreSQL?

PostgreSQL FAQ
PostgreSQL is distributed under the classic BSD license. Basically, it allows users to do anything they want with the code, including reselling binaries without the source code. The only restriction is that you not hold us legally liable for problems with the software. There is also the requirement that this copyright appear in all copies of the software.
Related Questions

What is PostgreSQL?

PostgreSQL FAQ
PostgreSQL is an enhancement of the POSTGRES database management system, a next-generation DBMS research prototype. While PostgreSQL retains the powerful data model and rich data types of POSTGRES, it replaces the PostQuel query language with an extended subset of SQL. PostgreSQL is free and the complete source is available. PostgreSQL development is performed by a team of Internet developers who all subscribe to the PostgreSQL development mailing list. The current coordinator is Marc G.
Related Questions

Web hosting and web design solutions for online personal and...
Like MySQL, PostgreSQL is another open source database software. We can add this at your request for free.
Related Questions

Frequently Asked Questions
Postgresql is a sophisticated, open-source (i.e., free) object-relational database management system that allows you to store and retrieve data according to various parameters given in a query and that supports almost all SQL constructs, including transactions and user-defined types. The PostgreSQL Global Development Group is a community of companies and people co-operating to drive the development of PostgreSQL, the world?s most advanced Open Source database software.
Related Questions

PostgreSQL FAQ
PostgreSQL is an enhancement of the POSTGRES database management system, a next-generation DBMS research prototype. While PostgreSQL retains the powerful data model and rich data types of POSTGRES, it replaces the PostQuel query language with an extended subset of SQL. PostgreSQL is free and the complete source is available. PostgreSQL development is being performed by a team of Internet developers who all subscribe to the PostgreSQL development mailing list. The current coordinator is Marc G.
Related Questions

What is PostgreSQL? How is it pronounced?

PostgreSQL: Frequently Asked Questions (FAQ) for PostgreSQL
PostgreSQL is pronounced Post-Gres-Q-L, and is also sometimes referred to as just Postgres. An audio file is available in MP3 format for those would like to hear the pronunciation. PostgreSQL is an object-relational database system that has the features of traditional commercial database systems with enhancements to be found in next-generation DBMS systems. PostgreSQL is free and the complete source code is available.
Related Questions

Who controls PostgreSQL?

PostgreSQL: Frequently Asked Questions (FAQ) for PostgreSQL
If you are looking for a PostgreSQL gatekeeper, central committee, or controlling company, give up --- there isn't one. We do have a core committee and CVS committers, but these groups are more for administrative purposes than control. The project is directed by the community of developers and users, which anyone can join. All you need to do is subscribe to the mailing lists and participate in the discussions.
Related Questions

What platforms does PostgreSQL support?

PostgreSQL FAQ
In general, any modern Unix-compatible platform should be able to run PostgreSQL. The platforms that had received explicit testing at the time of release are listed in the installation instructions. PostgreSQL also runs natively on Microsoft Windows NT-based operating systems like Win2000, WinXP, and Win2003. A prepackaged installer is available at http://pgfoundry.org/projects/pginstaller. MSDOS-based versions of Windows (Win95, Win98, WinMe) can run PostgreSQL using Cygwin.
Related Questions

How is PostgreSQL for Solaris different from PostgreSQL?

Solaris 10 Operating System - PostgreSQL FAQs
There is no difference. Moving forward the target is to get additional features and capabilities such as optimization and DTrace providers in order to take advantage of Solaris 10 advanced capabilities—These enhancements will be contributed back to the community and available in mainstream releases of PostgreSQL. Additionally, we plan to offer performance tuning tools, documentation and specific Solaris Software Offerings which integrate with PostgreSQL.
Related Questions

What interfaces are available for PostgreSQL?

PostgreSQL: Frequently Asked Questions (FAQ) for PostgreSQL
The PostgreSQL install includes only the C and embedded C interfaces. All other interfaces are independent projects that are downloaded separately; being separate allows them to have their own release schedule and development teams. Some programming languages like PHP include an interface to PostgreSQL. Interfaces for languages like Perl, TCL, Python, and many others are available at http://gborg.postgresql.org in the Drivers/Interfaces section and via Internet search.
Related Questions

What's the copyright on PostgreSQL?

PostgreSQL FAQ
Portions copyright (c) 1996-2000, PostgreSQL, Inc Portions Copyright (c) 1994-6 Regents of the University of California Permission to use, copy, modify, and distribute this software and its documentation for any purpose, without fee, and without a written agreement is hereby granted, provided that the above copyright notice and this paragraph and the following two paragraphs appear in all copies.
Related Questions

How can I see my Postgresql database?

Technical FAQ about Openbravo ERP - Developer at Openbravo
PostgreSQL has an admin tool called, pgAdmin III. It is very useful to introduce, see, update data in your Openbravo database. You can download in: http://sourceforge.net/project/showfiles.php?group_id=162271&package_id=192201
Related Questions

How does PostgreSQL compare to other DBMSs?

PostgreSQL: Frequently Asked Questions (FAQ) for PostgreSQL
There are several ways of measuring software: features, performance, reliability, support, and price. Features PostgreSQL has most features present in large commercial DBMSs, like transactions, subselects, triggers, views, foreign key referential integrity, and sophisticated locking. We have some features they do not have, like user-defined types, inheritance, rules, and multi-version concurrency control to reduce lock contention.
Related Questions

Why do I need to do a dump and restore to upgrade between major PostgreSQL releases?

PostgreSQL FAQ
The PostgreSQL team makes only small changes between minor releases, so upgrading from 7.4.0 to 7.4.1 does not require a dump and restore. However, major releases (e.g. from 7.3 to 7.4) often change the internal format of system tables and data files. These changes are often complex, so we don't maintain backward compatibility for data files. A dump outputs data in a generic format that can then be loaded in using the new internal format.
Related Questions

Does PostgreSQL have a graphical user interface?

PostgreSQL: Frequently Asked Questions (FAQ) for PostgreSQL
There are a large number of GUI Tools that are available for PostgreSQL from both commercial and open source developers. A detailed list can be found in the PostgreSQL Community Documentation
Related Questions

How does PostgreSQL compare to other DBMS's?

PostgreSQL FAQ
There are several ways of measuring software: features, performance, reliability, support, and price. Features PostgreSQL has most features present in large commercial DBMS's, like transactions, subselects, triggers, views, foreign key referential integrity, and sophisticated locking. We have some features they don't have, like user-defined types, inheritance, rules, and multi-version concurrency control to reduce lock contention. We don't have outer joins, but are working on them.
Related Questions

Are there ODBC drivers for PostgreSQL?

PostgreSQL FAQ
PsqlODBC is included in the distribution. More information about it can be gotten from ftp://ftp.PostgreSQL.org/pub/odbc/. OpenLink ODBC can be gotten from http://www.openlinksw.com. It works with their standard ODBC client software so you'll have PostgreSQL ODBC available on every client platform they support (Win, Mac, Unix, VMS). They will probably be selling this product to people who need commercial-quality support, but a freeware version will always be available.
Related Questions

What is the meaning of some of the terms used in PostgreSQL?

PostgreSQL FAQ
Some of the source code and older documentation use terms that have more common usage. Here are some: It is possible you have run out of virtual memory on your system, or your kernel has a low limit for certain resources. Try this before starting the postmaster: ulimit -d 65536 limit datasize 64m Depending on your shell, only one of these may succeed, but it will set your process data segment limit much higher and perhaps allow the query to complete.
Related Questions

Can I run PostgreSQL on a Windows architecture?

APLAWS+
The main PostgreSQL project plans to add support for a native Windows version with our 7.5 or 8.0 release. This will probably be released in early 2004, with that time estimate being based on 7.4 being due for release near the end of 2003. The free option at present is to use PostgreSQL running through Cygwin* That being all said and done however, we don't recommend using the cygwin version of PostgreSQL for "Production" quality databases, nor high load levels. http://techdocs.
Related Questions

How do I manage MySQL or PostgreSQL databases?

New Hosting FAQ - Website Hosting Canada
phpMyAdmin and phpPgAdmin are both installed and accessible via the control panel for web based management of databases. You can also manage database via shell access using 'mysql' or 'psql' programs respectively.
Related Questions

What is EMS SQL Manager for PostgreSQL?

SQL Manager | EMS SQL Manager for PostgreSQL | Product FAQs
EMS SQL Manager for PostgreSQL is a powerful graphical tool for PostgreSQL administration and development. It makes creating and editing PostgreSQL database objects easy and fast, and allows you to run SQL scripts, manage users and their privileges, build SQL queries visually, view database statistics, extract and print metadata, export/import data, view and edit BLOB fields, and much more.
Related Questions

Why cannot I connect to PostgreSQL Server?

SQL Manager | EMS SQL Manager for PostgreSQL | Product FAQs
Make sure that there is a record for your client PC in pg_hba.conf file on PostgreSQL server. This file can be found in database cluster's data directory. If you connect to the remote server, then the TCP/IP connections should be allowed on the remote server. In this case you need to edit file postgresql.conf on the server: just add the name or TCP/IP of the client PC in the listen_addresses list. Or you can as well put * character; in this case the connection from any host will be allowed.
Related Questions

Why can't I see my PostgreSQL table's columns?

DataVision FAQ
Upgrade your PostgreSQL JDBC driver if you are using Java 1.4. At least two PostgreSQL users were having different problems with PostgreSQL when upgrading to Java 1.4. They downloaded devpgjdbc3.jar and that seemed to fix their problems.
Related Questions

Got A Question? Ask Our Community!


More Questions >>

© Copyright 2007-2008 QueryCAT
About • Webmasters • Contact