SKU: 11624925007

PostgreSQL: Up and Running

Sale price$191.25 Regular price$212.50
Save 10%

Pay in installments of $53.12 with ShopPay, AfterPay and Klarna

Shipping Estimate
USA
  • USA
  • CAN

Ships within 48 hours · Estimated delivery Oct 1 - Oct 6

Promo Codes Available:

For Your Every Summer RSVP, with Code: SUMMER15

Description

PostgreSQL: Up and RunningIf youre thinking about migrating to the PostgreSQL open source database system, this guide provides a concise overview to help you quickly understand and use PostgreSQLs unique features. Not only will you learn about the enterprise class features in the 9. 2 release, youll also discover that PostgeSQL is more than just a database systemits also an impressive application platform."color: rgb(8, 113, 135); font family: Verdana; font size: 11px; text

If youre thinking about migrating to the PostgreSQL open source database system, this guide provides a concise overview to help you quickly understand and use PostgreSQLs unique features. Not only will you learn about the enterprise class features in the 9.2 release, youll also discover that PostgeSQL is more than just a database systemits also an impressive application platform."color: rgb(8, 113, 135); font-family: Verdana; font-size: 11px; text-align: justify;"With numerous examples throughout this book, youll learn how to achieve tasks that are difficult or impossible in other databases. If youre an existing PostgreSQL user, youll pick up gems you may have missed along the way.
Learn basic administration tasks, such as role management, database creation, backup, and restore
Apply the psql command-line utility and the pgAdmin graphical administration tool
Explore PostgreSQL tables, constraints, and indexes
Learn powerful SQL constructs not generally found in other databases
Use several different languages to write database functions
Tune your queries to run as fast as your hardware will allow
Query external and variegated data sources with Foreign Data Wrappers
Learn how to replicate data, using built-in replication features
Chapter 1 The Basics
Where to Get PostgreSQL
Administration Tools
Whats New in Latest Versions of PostgreSQL?
Database Drivers
Server and Database Objects
Where to Get Help
Chapter 2 Database Administration
Configuration Files
Setting Up Groups and Login Roles (Users)
Databases and Management
Extensions and Contribs
Backup
Restore
Managing Disk Space with Tablespaces
Verboten
Chapter 3 psql
Interactive psql
Non-Interactive psql
Session Configurations
psql Gems
Importing and Exporting Data
Basic Reporting
Chapter 4 Using pgAdmin
Getting Started
pgAdmin Features
pgScript
Graphical Explain
Job Scheduling with pgAgent
Chapter 5 Data Types
Numeric Data Types
Arrays
Character Types
Temporal Data Types
XML
Custom and Composite Data Types
Chapter 6 Of Tables, Constraints, and Indexes
Tables
Constraints
Indexes
Chapter 7 SQL: The PostgreSQL Way
SQL Views
Window Functions
Common Table Expressions
Constructions Unique to PostgreSQL
Chapter 8 Writing Functions
Anatomy of PostgreSQL Functions
Writing Functions with SQL
Writing PL/pgSQL Functions
Writing PL/Python Functions
Trigger Functions
Aggregates
Chapter 9 Query Performance Tuning
EXPLAIN and EXPLAIN ANALYZE
Writing Better Queries
Guiding the Query Planner
Caching
Chapter 10 Replication and External Data
Replication Overview
Setting Up Replication
Foreign Data Wrappers (FDW)
Appendix Install, Hosting, and Command-Line Guides
Installation Guides and Distributions
Where to Host PostgreSQL
PostgreSQL Packaged Command-Line Tools

Shipping Notes
  • Free Standard Shipping on $100+ Orders to the USA.
  • Except Preorder products are shipped in 48 hours.
  • Delivery to the USA:
  1. Standard Shipping : 3-10 business days
  • If time is of the essence, please consider selecting expedited delivery for faster service.
Exchange/Return Notes
  • We offer a 30-day return/exchange service after receiving.
  • Final sale items are not eligible for returns or exchanges.
  • To process your return/exchange, please contact us at [email protected]
  • Please click here for more details>>> Return & Exchange Policy
SKU: 11624925007

Discover Niche Categories That Outsell

Top-Converting Item to Boost Your Average Order

4.1 ★★★★★
Based on 8 reviews
Sort
Highest Rating
Newest First
Oldest First
Product Reviews
M
Mark Weinberg
Dallas, US
★★★★★ 5
Stable, attractive, and easy to turn into a table with your choice of top
Size: side table leg
The X-shape of the table legs - constructed with solid metal flanges, T-joints, X-joints and 1-inch diameter pipes - provides a strong and sturdy base for a wood top. The legs have adjustable feet pads to prevent scratches and ensure stability. Assembly of the legs is relatively simple (the instructions are clear) but you will need your own tools to attach a top. The industrial design is especially well suited to rec room or finished basement use. I am adding a 28" diameter raw edge slab of wood from a recently felled tree as the top and it is very attractive. (Photo unavailable because after I made certain it would work I sent the slab out for drying and finishing.) If you want a custom table and have a particular piece of wood you want to use, these legs are an excellent choice.
WAS THIS REVIEW HELPFUL?YesReportShare
Reviewed in the United States on March 18, 2026
G
Grammar Guru
Louisville, US
★★★★★ 5
Very nice kit: Beware it is NOT heavy duty plumbing pipe though!
Size: side table leg
I want to give this kit a high rating, but I need to address the "truth in advertising" bit since there may be an important disconnect between what you think you are getting and what actually comes in the box. Black plumbing used for shelving or table legs is part of an important niche in interior design. I like the industrial loft look myself and have a variety of glass, steel, and masonry elements in my home. This kit fits that look and provides plenty of "strength" for most domestic uses, like shelves or coffee tables. But they are NOT "industrial pipe" or "maximum durability pipe." Note the phrase "cast iron finish feet," which together with the other claims might lead you to think these are cast plumbing fittings. They are NOT! The feet and flanges feel like electrical conduit fittings, and the pipe sections are likely aluminum. They might be electrical or they might be multi-use, lightweight pipe. While all this might lead you to think that you're getting a truly retro, heavy-duty pipe kit made of black plumbing pipe, you are not. But, does it matter? Depends. I find the lighter pipe's smooth finish a nice "tone-down" from the rough plumbing look. All together, this kit provides plenty of strength for most furniture and the rustic pipe look, but with a nicer, lighter finish. To me that is a plus--this is a very nice kit and costs less that if you'd pieced it together from real plumbing parts (I priced it out to compare), and looks retro but cleaner. I knew what to expect because while I got this kit free on Vine, I had purchased a nearly identical kit from another seller last year. So, I'm giving it 5 stars for what it actually is and for the price, JUST BE AWARE THE NARRATIVE IS MISLEADING. Which is unfortunate because just like some people might want the heavier pipe, I'm betting more would be attracted to the look with a cleaner, lighter feel.
WAS THIS REVIEW HELPFUL?YesReportShare
Reviewed in the United States on December 31, 2025
C
Verified Purchase
César Guzmán
Louisville, US
★★★★★ 5
Libro de referencia
Format: Paperback
Execelente libros de referencia.!. El médico de la familia está encantado.!. Muy recomendable
WAS THIS REVIEW HELPFUL?YesReportShare
Reviewed in the United States on December 28, 2025
A
Verified Purchase
Alfred
Dallas, US
★★★★★ 5
item as describes, fast shipping
Format: Paperback
great seller fast shipping
WAS THIS REVIEW HELPFUL?YesReportShare
Reviewed in the United States on July 22, 2021
J
John A. Sandoval
Chelsea, US
★★★★★ 5
Pocketable Backup
Format: Paperback
OK... No computer, No Cell Service, No Electricity, No WiFi, No Radio, Oh My God... No Kindle... RATS! Let me see... There it is... My Emergency & Critical Care Pocket Guide... YEP! Even stagnating in the bottom of your bag its reassuring to have a backup...
WAS THIS REVIEW HELPFUL?YesReportShare
Reviewed in the United States on January 9, 2023

recommand products