![]()
Instant PostgreSQL Starter
![]()
Instant PostgreSQL Starter
Copyright Β© 2013 Packt Publishing
All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.
Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the Daniel K. Lyons, nor Packt Publishing, and its dealers and distributors will be held liable for any damages caused or alleged to be caused directly or indirectly by this book.
Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information.
First published: April 2013
Production Reference: 1180413
Published by Packt Publishing Ltd.
Livery Place
35 Livery Street
Birmingham B3 2PB, UK.
ISBN 978-1-78216-756-3
![]()
Author
Daniel K. Lyons
Reviewer
Reid Givens
Acquisition Editor
Erol Staveley
Commissioning Editor
Ameya Sawant
Technical Editor
Saijul Shah
Project Coordinator
Suraj Bist
Proofreader
Mario Cecere
Production Coordinator
Arvindkumar Gupta
Cover Work
Arvindkumar Gupta
Cover Image
Nitesh Thakur
![]()
Daniel K. Lyons is a programmer and database administrator at the NRAO in Socorro, NM. He's been using PostgreSQL professionally and privately for a decade and it is one of the few technologies that he likes despite much use. In his spare time he likes to program in Haskell and Prolog.
![]()
Reid Givens is the owner of Viaduct Digital, LLC, a digital media, and web development agency out of New Mexico. Reid received a degree in Interactive Media from the International Academy of Design and Technology in 2001. Reid started his career as a creative, working as a print, and web designer for small agencies. Since then, he has moved from graphic designer to creative director, advertising manager, and a few years as an organizational strategist until starting his own agency in 2007. He also speaks about marketing and the web, and has spent a few years running his own digital agency. Reid has also been known to pick up drumsticks from time to time.
![]()
Support files, eBooks, discount offers and more
You might want to visit
www.packtpub.com for support files and downloads related to your book.
Did you know that Packt offers eBook versions of every book published, with PDF and ePub files available? You can upgrade to the eBook version at
www.packtpub.com and as a print book customer, you are entitled to a discount on the eBook copy. Get in touch with us at
<[email protected]>
for more details.
At
www.packtpub.com, you can also read a collection of free technical articles, sign up for a range of free newsletters and receive exclusive discounts and offers on Packt books and eBooks.
![]()
Do you need instant solutions to your IT questions? PacktLib is Packt's online digital book library. Here, you can access, read and search across Packt's entire library of books.
- Fully searchable across every book published by Packt
- Copy and paste, print and bookmark content
- On demand and accessible via web browser
![]()
Free Access for Packt account holders
If you have an account with Packt at
www.packtpub.com, you can use this to access PacktLib today and view nine entirely free books. Simply use your login credentials for immediate access.
![]()
Chapter 1. Instant PostgreSQL Starter
Welcome to the Instant PostgreSQL Starter. This book has been especially created to provide you with all the information that you need to get set up with PostgreSQL. You will learn the basics of PostgreSQL, get started with installing your first database, and discover some tips and tricks for using and running PostgreSQL.
This document contains the following sections:
So, what is PostgreSQL? finds out what PostgreSQL actually is, what you can do with it, and why it's the most advanced open-source relational database management system.
Installation will show you how to download and install PostgreSQL with the minimum fuss and then set it up so that you can use it as soon as possible. We will take a brief detour afterwards to discuss a few important settings and how they affect performance.
Quick start β Creating your first table section will show you how to perform two of the core tasks of PostgreSQL; creating databases and users. Follow the steps to create your own database and administrator account, which will be the basis of most of your work in PostgreSQL.
Top 9 features you need to know about here you will learn how to perform six tasks with the most important features of PostgreSQL. By the end of this section you will be able to insert data and perform queries, examine database structure and size, backup and restore databases, import and export data to CSV, install extensions, and store unstructured data and passwords securely.
People and places you should get to know section provides you with many useful links to the project page and forums, as well as a number of helpful articles, tutorials, blogs, and the Twitter feeds of PostgreSQL super-contributors.
PostgreSQL is the premier open-source relational database. Long the underdog of the database world, its recent surge in popularity has come from users of other databases searching for a system with better reliability guarantees, better querying ca...