diff options
author | Bruce Momjian <bruce@momjian.us> | 2000-06-24 01:51:14 +0000 |
---|---|---|
committer | Bruce Momjian <bruce@momjian.us> | 2000-06-24 01:51:14 +0000 |
commit | 3fb8c9d1f9dc28ee185a5e545ac39b146c9063eb (patch) | |
tree | b3ca7ca1a10386cbd249322858401a1a09d7d65d /doc/FAQ | |
parent | c4465095659bb089e08f8c94ce045ba3572a194f (diff) | |
download | postgresql-3fb8c9d1f9dc28ee185a5e545ac39b146c9063eb.tar.gz postgresql-3fb8c9d1f9dc28ee185a5e545ac39b146c9063eb.zip |
Update FAQ.
Diffstat (limited to 'doc/FAQ')
-rw-r--r-- | doc/FAQ | 23 |
1 files changed, 11 insertions, 12 deletions
@@ -335,11 +335,11 @@ Features PostgreSQL has most features present in large commercial - DBMS's, like transactions, subselects, triggers, views, 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 - foreign key referential integrity or outer joins, but are + 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 for our next release. Performance @@ -396,10 +396,10 @@ 2.1) Are there ODBC drivers for PostgreSQL? - There are two ODBC drivers available, PostODBC and OpenLink ODBC. + There are two ODBC drivers available, PsqlODBC and OpenLink ODBC. - PostODBC is included in the distribution. More information about it - can be gotten from: http://www.insightdist.com/psqlodbc + PsqlODBC is included in the distribution. More information about it + can be gotten from: ftp://ftp.postgresql.org/pub/odbc/index.html OpenLink ODBC can be gotten from http://www.openlinksw.com. It works with their standard ODBC client software so you'll have PostgreSQL @@ -410,6 +410,8 @@ commercial-quality support, but a freeware version will always be available. Questions to postgres95@openlink.co.uk. + See also the ODBC chapter of the Programmer's Guide. + 2.2) What tools are available for hooking PostgreSQL to Web pages? A nice introduction to Database-backed Web pages can be seen at: @@ -972,12 +974,9 @@ BYTEA bytea variable-length array of bytes 4.22) How do I create a column that will default to the current time? - This way always works: + Use now(): CREATE TABLE test (x int, modtime timestamp default now() ); - In releases 7.0 and later, you may use: - create table test (x int, modtime timestamp default 'now'); - 4.23) Why are my subqueries using IN so slow? Currently, we join subqueries to outer queries by sequential scanning |