CHAPTER 27 The Many PostgreSQL (Affordable web hosting)
CHAPTER 27 The Many PostgreSQL Clients PostgreSQL is bundled with quite a few utilities, or clients, each of which provides interfaces for carrying out various tasks pertinent to server administration. This chapter offers an in-depth introduction to the most prominent of the bunch, namely psql. Because the psql manual already does a great job at providing a general overview of each client, we ll instead focus on those features that you re most likely to use regularly in your daily administration activities. We ll show you how to log on and off a PostgreSQL server, explain how to set key environment variables both manually and through configuration files, and offer general tips intended to help you maximize your interaction with psql. Also, because many readers prefer to use a graphical user interface (GUI) to manage PostgreSQL, the chapter concludes with a brief survey of three GUIbased administration applications. As is the goal with all chapters in this book, the following topics are presented in an order and format that are conducive to helping a novice learn about psql s key features while simultaneously acting as an efficient reference guide for all readers. Therefore, if you re new to psql, begin with the first section and work through the material and examples. If you re a returning reader, feel free to jump around as you see fit. Specifically, the following topics are presented in this chapter: An introduction to psql: This chapter introduces the psql client along with many of the options that you ll want to keep in mind to maximize its usage. Commonplace psql tasks: You ll see how to execute many of psql s commonplace commands, including how to log on and off a PostgreSQL server, use configuration files to set environment variables and tweak psql s behavior, read in and edit commands found within external files, and more. GUI-based clients: Because not all users prefer or even have access to the command line, considerable effort has been put into commercial- and community-driven GUIbased PostgreSQL administration solutions, several of the more popular of which are introduced in this chapter. What Is psql? For those of you who prefer the command-line interface over GUI-based alternatives, psql offers a powerful means for managing every aspect of the PostgreSQL server. Bundled with the PostgreSQL distribution, psql is akin to MySQL s mysql client and Oracle s SQL*Plus tool. With it, you can create and delete databases, tablespaces, and tables, execute transactions, execute
Go visit our java server pages services for a reliable, lowcost webhost to satisfy all your needs.