PostgreSQL: Introduction and Concepts (Paperback)
Bruce Momjian
- 出版商: Addison Wesley
- 出版日期: 2000-12-15
- 售價: $1,920
- 貴賓價: 9.5 折 $1,824
- 語言: 英文
- 頁數: 462
- 裝訂: Paperback
- ISBN: 0201703319
- ISBN-13: 9780201703313
-
相關分類:
PostgreSQL、SQL
已絕版
買這商品的人也買了...
-
$1,029Fundamentals of Data Structures in C++
-
$1,400$1,372 -
$675Network Analysis and Troubleshooting (Hardcover)
-
$699TCP/IP Addressing: Designing and Optimizing Your Ip Addressing Scheme, 2/e
-
$790Network Intrusion Detection, 2/e
-
$450$351 -
$1,520Linux System Administration: A User's Guide
-
$1,690$1,606 -
$1,294Web Services: A Technical Introduction
-
$880$704 -
$560$504 -
$650$553 -
$280$221 -
$420$420 -
$690$538 -
$750$675 -
$680$666 -
$1,540$1,463 -
$1,127Operating System Concepts with Java, 6/e (IE) (美國版ISBN:0471489050)
-
$1,176Computer Organization and Design: The Hardware/Software Interface, 3/e(IE) (美國版ISBN:1558606041)
-
$490Perfect Passwords: Selection, Protection and Authentication
-
$550$468 -
$1,050$998 -
$890$757 -
$296PostgreSQL 即學即用, 2/e (PostgreSQL: Up and Running: A Practical Introduction to the Advanced Open Source Database, 2/e)
相關主題
商品描述
Description
The insider's guide to PostgreSQL, the world's most sophisticated, scalable open source database!
- A complete PostgreSQL tutorial, reference, and real-world application guide.
- Covers SQL commands, query tools, data import/export, joins, transactions, optimization, administration, extensions, programming interfaces, and more.
- Authored by a founding member of the PostgreSQL development team.
Bruce Momjian is a founding member of the PostgreSQL Global Development Team. He is currently a senior consultant with Wilson Technology Associates in Newtown Square, PA, designing and developing relational database applications for major law firms.
Table Of Contents
List of Figures.List of Tables.
Foreword.
Preface.
Acknowledgments.
Steering.
Major Developers.
Non-code Contributors.
Major Developers.
Non-code Contributors.
History of POSTGRESQL.
Introduction.
University of California at Berkeley.
Development Leaves Berkeley.
POSTGRESQL Global Development Team.
Open Source Software.
Summary.
University of California at Berkeley.
Development Leaves Berkeley.
POSTGRESQL Global Development Team.
Open Source Software.
Summary.
Issuing Database Commands.
Starting a Database Session.
Choosing an Interface.
Choosing a Database.
Starting a Session.
Choosing a Database.
Starting a Session.
Controlling a Session.
Typing in the Query Buffer.
Displaying the Query Buffer.
Erasing the Query Buffer.
Getting Help.
Exiting a Session.
Summary.
Displaying the Query Buffer.
Erasing the Query Buffer.
Getting Help.
Exiting a Session.
Summary.
Basic SQL Commands.
Relational Databases.
Creating Tables.
Adding Data with INSERT.
Viewing Data with SELECT.
Selecting Specific Rows with WHERE.
Removing Data with DELETE.
Modifying Data with UPDATE.
Sorting Data with ORDER BY.
Destroying Tables.
Summary.
Creating Tables.
Adding Data with INSERT.
Viewing Data with SELECT.
Selecting Specific Rows with WHERE.
Removing Data with DELETE.
Modifying Data with UPDATE.
Sorting Data with ORDER BY.
Destroying Tables.
Summary.
Customizing Queries.
Data Types.
Quotes Inside Text.
Using NULL Values.
Controlling DEFAULT Values.
Column Labels.
Comments.
AND/OR Usage.
Range of Values.
LIKE Comparison.
Regular Expressions.
CASE Clause.
Distinct Rows.
Functions and Operators.
SET, SHOW, and RESET.
Summary.
Quotes Inside Text.
Using NULL Values.
Controlling DEFAULT Values.
Column Labels.
Comments.
AND/OR Usage.
Range of Values.
LIKE Comparison.
Regular Expressions.
CASE Clause.
Distinct Rows.
Functions and Operators.
SET, SHOW, and RESET.
Summary.
SQL Aggregates.
Aggregates.
Using GROUP BY.
Using HAVING.
Query Tips.
Summary.
Using GROUP BY.
Using HAVING.
Query Tips.
Summary.
Joining Tables.
Table and Column References.
Joined Tables.
Creating Joined Tables.
Performing Joins.
Three- and Four-Table Joins.
Additional Join Possibilities.
Choosing a Join Key.
One-to-Many Joins.
Unjoined Tables.
Table Aliases and Self-joins.
Non-equijoins.
Ordering Multiple Parts.
Primary and Foreign Keys.
Summary.
Joined Tables.
Creating Joined Tables.
Performing Joins.
Three- and Four-Table Joins.
Additional Join Possibilities.
Choosing a Join Key.
One-to-Many Joins.
Unjoined Tables.
Table Aliases and Self-joins.
Non-equijoins.
Ordering Multiple Parts.
Primary and Foreign Keys.
Summary.
Numbering Rows.
Object Identification Numbers (OIDs).
Object Identification Number Limitations.
Sequences.
Creating Sequences.
Using Sequences to Number Rows.
Serial Column Type.
Manually Numbering Rows.
Summary.
Object Identification Number Limitations.
Nonsequential Numbering.
Nonmodifiable.
Not Backed Up by Default.
Nonmodifiable.
Not Backed Up by Default.
Sequences.
Creating Sequences.
Using Sequences to Number Rows.
Serial Column Type.
Manually Numbering Rows.
Summary.
Combining SELECTs.
UNION, EXCEPT, and INTERSECT Clauses.
Subqueries.
Outer Joins.
Subqueries in Non-SELECT Queries.
UPDATE with FROM.
Inserting Data Using SELECT.
Creating Tables Using SELECT.
Summary.
Subqueries.
Subqueries as Constants.
Subqueries as Correlated Values.
Subqueries as Lists of Values.
NOT IN and Subqueries with NULL Values.
Subqueries Returning Multiple Columns.
ANY, ALL, and EXISTS Clauses.
Summary.
Subqueries as Correlated Values.
Subqueries as Lists of Values.
NOT IN and Subqueries with NULL Values.
Subqueries Returning Multiple Columns.
ANY, ALL, and EXISTS Clauses.
Summary.
Outer Joins.
Subqueries in Non-SELECT Queries.
UPDATE with FROM.
Inserting Data Using SELECT.
Creating Tables Using SELECT.
Summary.
Data Types.
Purpose of Data Types.
Installed Types.
Type Conversion Using CAST.
Support Functions.
Support Operators.
Support Variables.
Arrays.
Large Objects (BLOBs).
Summary.
Installed Types.
Character String.
Number.
Temporal.
Logical.
Geometric.
Network.
Internal.
Number.
Temporal.
Logical.
Geometric.
Network.
Internal.
Type Conversion Using CAST.
Support Functions.
Support Operators.
Support Variables.
Arrays.
Large Objects (BLOBs).
Summary.
Transactions and Locks.
Transactions.
Multistatement Transactions.
Visibility of Committed Transactions.
Read Committed and Serializable Isolation Levels.
Locking.
Deadlocks.
Summary.
Multistatement Transactions.
Visibility of Committed Transactions.
Read Committed and Serializable Isolation Levels.
Locking.
Deadlocks.
Summary.
Performance.
Indexes.
Unique Indexes.
CLUSTER.
VACUUM.
VACUUM ANALYZE.
EXPLAIN.
Summary.
Unique Indexes.
CLUSTER.
VACUUM.
VACUUM ANALYZE.
EXPLAIN.
Summary.
Controlling Results.
LIMIT.
Cursors.
Summary.
Cursors.
Summary.
Table Management.
Temporary Tables.
ALTER TABLE.
GRANT and REVOKE.
Inheritance.
Views.
Rules.
LISTEN and NOTIFY.
Summary.
ALTER TABLE.
GRANT and REVOKE.
Inheritance.
Views.
Rules.
LISTEN and NOTIFY.
Summary.
Constraints.
NOT NULL.
UNIQUE.
PRIMARY KEY.
Foreign Key/REFERENCES.
CHECK.
Summary.
UNIQUE.
PRIMARY KEY.
Foreign Key/REFERENCES.
Modification of Primary Key Row.
Multicolumn Primary Keys.
Handling NULL Values in the Foreign Key.
Frequency of Foreign Key Checking.
Multicolumn Primary Keys.
Handling NULL Values in the Foreign Key.
Frequency of Foreign Key Checking.
CHECK.
Summary.
Importing and Exporting Data.
Using COPY.
COPY File Format.
DELIMITERS.
COPY Without Files.
Backslashes and NULL Values.
COPY Tips.
Summary.
COPY File Format.
DELIMITERS.
COPY Without Files.
Backslashes and NULL Values.
COPY Tips.
Summary.
Database Query Tools.
Psql.
Psql Command-line Arguments and Start-up File.
Pgaccess.
Summary.
Query Buffer Commands.
General Commands.
Output Format Options.
Output Format Shortcuts.
Variables.
Listing Commands.
Large Object Commands.
General Commands.
Output Format Options.
Output Format Shortcuts.
Variables.
Listing Commands.
Large Object Commands.
Psql Command-line Arguments and Start-up File.
Pgaccess.
Summary.
Programming Interfaces.
C Language Interface (LIBPQ).
Pgeasy (LIBPGEASY).
Embedded C (ECPG).
C++ (LIBPQ++).
Compiling Programs.
Assignment to Program Variables.
ODBC.
Java (JDBC).
Scripting Languages.
Perl.
TCL/TK (PGTCLSH/PGTKSH).
Python.
PHP.
Installing Scripting Languages.
Summary.
Pgeasy (LIBPGEASY).
Embedded C (ECPG).
C++ (LIBPQ++).
Compiling Programs.
Assignment to Program Variables.
ODBC.
Java (JDBC).
Scripting Languages.
Perl.
TCL/TK (PGTCLSH/PGTKSH).
Python.
PHP.
Installing Scripting Languages.
Summary.
Functions and Triggers.
Functions.
SQL Functions.
PL/PGSQL Functions.
Triggers.
Summary.
SQL Functions.
PL/PGSQL Functions.
Triggers.
Summary.
Extending POSTGRESQL Using C.
Write the C Code.
Compile the C Code.
Register the New Functions.
Create Operators, Types, and Aggregates.
Summary.
Compile the C Code.
Register the New Functions.
Create Operators, Types, and Aggregates.
Summary.
Administration.
Files.
Creating Users.
Creating Databases.
Access Configuration.
Backup and Restore.
Server Start-up and Shutdown.
Monitoring.
Performance.
System Tables.
Internationalization.
Upgrading.
Summary.
Creating Users.
Creating Databases.
Access Configuration.
Local.
Host and Hostssl.
User Mappings.
Examples.
Host and Hostssl.
User Mappings.
Examples.
Backup and Restore.
Server Start-up and Shutdown.
Monitoring.
Performance.
System Tables.
Internationalization.
Upgrading.
Summary.
Additional Resources.
Mailing List Support.
Supplied Documentation.
Commercial Support.
Modifying the Source Code.
Frequently Asked Questions (FAQs).
Supplied Documentation.
Commercial Support.
Modifying the Source Code.
Frequently Asked Questions (FAQs).
Installation.
Getting POSTGRESQL.
Creating the POSTGRESQL User.
Configuration.
Compilation.
Installation.
Initialization.
Starting the Server.
Creating a Database.
Creating the POSTGRESQL User.
Configuration.
Compilation.
Installation.
Initialization.
Starting the Server.
Creating a Database.
PostgreSQL Nonstandard Features by Chapter.
Reference Manual.
ABORT.
ALTER GROUP.
ALTER TABLE.
ALTER USER.
BEGIN.
CLOSE.
CLUSTER.
COMMENT.
COMMIT.
COPY.
CREATE AGGREGATE.
CREATE CONSTRAINT TRIGGER.
CREATE DATABASE.
CREATE FUNCTION.
CREATE GROUP.
CREATE INDEX.
CREATE LANGUAGE.
CREATE OPERATOR.
CREATE RULE.
CREATE SEQUENCE.
CREATE TABLE.
CREATE TABLE AS.
CREATE TRIGGER.
CREATE TYPE.
CREATE USER.
CREATE VIEW.
createdb.
createlang.
createuser.
DECLARE.
DELETE.
DROP AGGREGATE.
DROP DATABASE.
DROP FUNCTION.
DROP GROUP.
DROP INDEX.
DROP LANGUAGE.
DROP OPERATOR.
DROP RULE.
DROP SEQUENCE.
DROP TABLE.
DROP TRIGGER.
DROP TYPE.
DROP USER.
DROP VIEW.
dropdb.
droplang.
dropuser.
ecpg.
END.
EXPLAIN.
FETCH.
GRANT.
initdb.
initlocation.
INSERT.
ipcclean.
LISTEN.
LOAD.
LOCK.
MOVE.
NOTIFY.
pg_ctl.
pg_dump.
pg_dumpall.
pg_passwd.
pg_upgrade.
pgaccess.
pgtclsh.
pgtksh.
postgres.
postmaster.
psql.
REINDEX.
RESET.
REVOKE.
ROLLBACK.
SELECT.
SELECT INTO.
SET.
SHOW.
TRUNCATE.
UNLISTEN.
UPDATE.
VACUUM.
vacuumdb.
ALTER GROUP.
ALTER TABLE.
ALTER USER.
BEGIN.
CLOSE.
CLUSTER.
COMMENT.
COMMIT.
COPY.
CREATE AGGREGATE.
CREATE CONSTRAINT TRIGGER.
CREATE DATABASE.
CREATE FUNCTION.
CREATE GROUP.
CREATE INDEX.
CREATE LANGUAGE.
CREATE OPERATOR.
CREATE RULE.
CREATE SEQUENCE.
CREATE TABLE.
CREATE TABLE AS.
CREATE TRIGGER.
CREATE TYPE.
CREATE USER.
CREATE VIEW.
createdb.
createlang.
createuser.
DECLARE.
DELETE.
DROP AGGREGATE.
DROP DATABASE.
DROP FUNCTION.
DROP GROUP.
DROP INDEX.
DROP LANGUAGE.
DROP OPERATOR.
DROP RULE.
DROP SEQUENCE.
DROP TABLE.
DROP TRIGGER.
DROP TYPE.
DROP USER.
DROP VIEW.
dropdb.
droplang.
dropuser.
ecpg.
END.
EXPLAIN.
FETCH.
GRANT.
initdb.
initlocation.
INSERT.
ipcclean.
LISTEN.
LOAD.
LOCK.
MOVE.
NOTIFY.
pg_ctl.
pg_dump.
pg_dumpall.
pg_passwd.
pg_upgrade.
pgaccess.
pgtclsh.
pgtksh.
postgres.
postmaster.
psql.
REINDEX.
RESET.
REVOKE.
ROLLBACK.
SELECT.
SELECT INTO.
SET.
SHOW.
TRUNCATE.
UNLISTEN.
UPDATE.
VACUUM.
vacuumdb.
Bibliography.
Index. 0201703319T04062001