Holdings: Practical PostgreSQL

Practical PostgreSQL:

Saved in:

Bibliographic Details
Main Authors:	Worsley, John C. (Author), Drake, Joshua D. (Author)
Format:	Book
Language:	English
Published:	Beijing [u.a.] O'Reilly 2002
Edition:	1. ed.
Subjects:	PostgreSQL Database management PostgreSQL 7.1
Online Access:	Inhaltsverzeichnis
Physical Description:	XIV, 619 S. 1 CD-ROM ; 12 cm
ISBN:	1565928466

Staff View

MARC


LEADER	00000nam a2200000 c 4500
001	BV014068998
003	DE-604
005	20130722
007	t
008	011220s2002 \|\|\|\| 00\|\|\| eng d
016	7		\|a 963775502 \|2 DE-101
020			\|a 1565928466 \|9 1-56592-846-6
035			\|a (OCoLC)316454734
035			\|a (DE-599)BVBBV014068998
040			\|a DE-604 \|b ger \|e rakwb
041	0		\|a eng
049			\|a DE-29T \|a DE-573 \|a DE-706 \|a DE-526 \|a DE-11
082	0		\|a 005.7565 \|2 21
084			\|a ST 271 \|0 (DE-625)143639: \|2 rvk
100	1		\|a Worsley, John C. \|e Verfasser \|4 aut
245	1	0	\|a Practical PostgreSQL \|c John C. Worsley and Joshua D. Drake
250			\|a 1. ed.
264		1	\|a Beijing [u.a.] \|b O'Reilly \|c 2002
300			\|a XIV, 619 S. \|e 1 CD-ROM ; 12 cm
336			\|b txt \|2 rdacontent
337			\|b n \|2 rdamedia
338			\|b nc \|2 rdacarrier
630	0	4	\|a PostgreSQL
650		4	\|a Database management
650	0	7	\|a PostgreSQL 7.1 \|0 (DE-588)4650184-8 \|2 gnd \|9 rswk-swf
689	0	0	\|a PostgreSQL 7.1 \|0 (DE-588)4650184-8 \|D s
689	0		\|5 DE-604
700	1		\|a Drake, Joshua D. \|e Verfasser \|4 aut
856	4	2	\|m DNB Datenaustausch \|q application/pdf \|u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=009635568&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA \|3 Inhaltsverzeichnis
943	1		\|a oai:aleph.bib-bvb.de:BVB01-009635568

Record in the Search Index

_version_	1808045778668617728
adam_text	TABLE OF CONTENTS PREFACE . IX I: INTRODUCTION & INSTALLATION . 1 1: WHAT IS POSTGRESQL? . 3 OPEN SOURCE FREE VERSION . 3 POSTGRESQL FEATURE SET . 6 WHERE TO PROCEED FROM HERE . 7 2: INSTALLING POSTGRESQL . 9 PREPARING FOR INSTALLATION . 9 10 STEPS TO INSTALLING POSTGRESQL . 13 II: USING POSTGRESQL . 31 3: UNDERSTANDING SQL .33 INTRODUCTION TO SQL . 33 INTRODUCTION TO RELATIONAL DATABASES . 35 SQL STATEMENTS . 39 DATA TYPES . 59 TABLES IN POSTGRESQL . 86 VI TABLE OF CONTENTS 4: USING SQL WITH POSTGRESQL . 91 INTRODUCTION TO PSQL . 91 USING TABLES . 95 ADDING DATA WITH INSERT AND COPY . 107 RETRIEVING ROWS WITH SELECT . 112 MODIFYING ROWS WITH UPDATE . 145 REMOVING ROWS WITH DELETE . 148 USING SUB-QUERIES . 150 USING VIEWS . 152 FURTHER SQL APPLICATION . 155 5: OPERATORS AND FUNCTIONS . 157 OPERATORS . 157 FUNCTIONS . 175 6: POSTGRESQL CLIENTS . 221 THE PSQL CLIENT: ADVANCED TOPICS . 221 PGACCESS-. A GRAPHICAL CLIENT . 238 7: ADVANCED FEATURES . 247 INDICES . 247 ADVANCED TABLE TECHNIQUES . 252 ARRAYS . 264 AUTOMATING COMMON ROUTINES . 271 TRANSACTIONS AND CURSORS . 283 EXTENDING POSTGRESQL . 290 III: ADMINISTRATING POSTGRESQL . 301 8: AUTHENTICATION AND ENCRYPTION . 303 CLIENT AUTHENTICATION . 303 ENCRYPTING SESSIONS . 315 9: DATABASE MANAGEMENT . 327 STARTING AND STOPPING POSTGRESQL . 327 INITIALIZING THE FILESYSTEM . 336 CREATING AND REMOVING A DATABASE . 339 MAINTAINING A DATABASE . 347 BACKING UP AND RESTORING DATA . 353 TABLE OF CONTENTS VII 10: USER AND GROUP MANAGEMENT . 369 MANAGING USERS . 369 MANAGING GROUPS . 379 GRANTING PRIVILEGES . 383 IV: POSTGRESQL PROGRAMMING . 389 11: PL/PGSQL . 391 ADDING PL/PGSQL TO YOUR DATABASE . 391 LANGUAGE STRUCTURE . 394 USING VARIABLES . 398 . CONTROLLING PROGRAM FLOW . 412 PL/PGSQL AND TRIGGERS . 428 12: JDBC . 433 BUILDING" THE POSTGRESQL JDBC DRIVER . 434 USING THE POSTGRESQL DRIVER . 434 USING JDBC . 437 ISSUES SPECIFIC TO POSTGRESQL AND JDBC . 444 13: LXP . 447 WHY USE LXP? . 448 CORE FEATURES . 448 INSTALLING AND CONFIGURING LXP . 450 UNDERSTANDING LXP MARK-UP . 456 LXP VARIABLES AND OBJECTS . 459 USING COOKIES WITH LXP . 462 TAG PARSING . 464 BRANCHING LOGIC . 468 LOOP ITERATION . 473 CONTENT INCLUSION . 475 DISPLAYING FOREIGN TAGS WITH XTAG . 487 VIII TABLE OF CONTENTS V: COMMAND REFERENCE . 491 14: POSTGRESQL COMMAND REFERENCE . 493 A: MULTIBYTE ENCODING TYPES . 599 B: BACKEND OPTIONS FOR POSTGRES . 601 C: BINARY COPY FORMAT . 605 D: INTERNAL PSQL VARIABLES .609 INDEX . 613
any_adam_object	1
author	Worsley, John C. Drake, Joshua D.
author_facet	Worsley, John C. Drake, Joshua D.
author_role	aut aut
author_sort	Worsley, John C.
author_variant	j c w jc jcw j d d jd jdd
building	Verbundindex
bvnumber	BV014068998
classification_rvk	ST 271
ctrlnum	(OCoLC)316454734 (DE-599)BVBBV014068998
dewey-full	005.7565
dewey-hundreds	000 - Computer science, information, general works
dewey-ones	005 - Computer programming, programs, data, security
dewey-raw	005.7565
dewey-search	005.7565
dewey-sort	15.7565
dewey-tens	000 - Computer science, information, general works
discipline	Informatik
edition	1. ed.
format	Book
fullrecord	<?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>00000nam a2200000 c 4500</leader><controlfield tag="001">BV014068998</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20130722</controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">011220s2002 \|\|\|\| 00\|\|\| eng d</controlfield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">963775502</subfield><subfield code="2">DE-101</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1565928466</subfield><subfield code="9">1-56592-846-6</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)316454734</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV014068998</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rakwb</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-29T</subfield><subfield code="a">DE-573</subfield><subfield code="a">DE-706</subfield><subfield code="a">DE-526</subfield><subfield code="a">DE-11</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.7565</subfield><subfield code="2">21</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 271</subfield><subfield code="0">(DE-625)143639:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Worsley, John C.</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Practical PostgreSQL</subfield><subfield code="c">John C. Worsley and Joshua D. Drake</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">1. ed.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Beijing [u.a.]</subfield><subfield code="b">O'Reilly</subfield><subfield code="c">2002</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XIV, 619 S.</subfield><subfield code="e">1 CD-ROM ; 12 cm</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="630" ind1="0" ind2="4"><subfield code="a">PostgreSQL</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Database management</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">PostgreSQL 7.1</subfield><subfield code="0">(DE-588)4650184-8</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">PostgreSQL 7.1</subfield><subfield code="0">(DE-588)4650184-8</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Drake, Joshua D.</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">DNB Datenaustausch</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=009635568&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="943" ind1="1" ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-009635568</subfield></datafield></record></collection>
id	DE-604.BV014068998
illustrated	Not Illustrated
indexdate	2024-08-22T00:33:41Z
institution	BVB
isbn	1565928466
language	English
oai_aleph_id	oai:aleph.bib-bvb.de:BVB01-009635568
oclc_num	316454734
open_access_boolean
owner	DE-29T DE-573 DE-706 DE-526 DE-11
owner_facet	DE-29T DE-573 DE-706 DE-526 DE-11
physical	XIV, 619 S. 1 CD-ROM ; 12 cm
publishDate	2002
publishDateSearch	2002
publishDateSort	2002
publisher	O'Reilly
record_format	marc
spelling	Worsley, John C. Verfasser aut Practical PostgreSQL John C. Worsley and Joshua D. Drake 1. ed. Beijing [u.a.] O'Reilly 2002 XIV, 619 S. 1 CD-ROM ; 12 cm txt rdacontent n rdamedia nc rdacarrier PostgreSQL Database management PostgreSQL 7.1 (DE-588)4650184-8 gnd rswk-swf PostgreSQL 7.1 (DE-588)4650184-8 s DE-604 Drake, Joshua D. Verfasser aut DNB Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=009635568&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis
spellingShingle	Worsley, John C. Drake, Joshua D. Practical PostgreSQL PostgreSQL Database management PostgreSQL 7.1 (DE-588)4650184-8 gnd
subject_GND	(DE-588)4650184-8
title	Practical PostgreSQL
title_auth	Practical PostgreSQL
title_exact_search	Practical PostgreSQL
title_full	Practical PostgreSQL John C. Worsley and Joshua D. Drake
title_fullStr	Practical PostgreSQL John C. Worsley and Joshua D. Drake
title_full_unstemmed	Practical PostgreSQL John C. Worsley and Joshua D. Drake
title_short	Practical PostgreSQL
title_sort	practical postgresql
topic	PostgreSQL Database management PostgreSQL 7.1 (DE-588)4650184-8 gnd
topic_facet	PostgreSQL Database management PostgreSQL 7.1
url	http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=009635568&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA
work_keys_str_mv	AT worsleyjohnc practicalpostgresql AT drakejoshuad practicalpostgresql

Holdings

There is no print copy available.

Interlibrary loan Place Request Caution: Not in THWS collection! Indexes

MARC

Record in the Search Index

There is no print copy available.

Similar Items