Practical PostgreSQL:
Gespeichert in:
| Hauptverfasser: | , |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
Beijing [u.a.]
O'Reilly
2002
|
| Ausgabe: | 1. ed. |
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis |
| Beschreibung: | XIV, 619 S. 1 CD-ROM ; 12 cm |
| ISBN: | 1565928466 |
Internformat
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 | |
Datensatz im Suchindex
| _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 |