Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com
Answertopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions
Privacy Policy

  




 

 

II. PostgreSQL Client Applications

This part contains reference information for PostgreSQL client applications and utilities. Not all of these commands are of general utility, some may require special privileges. The common feature of these applications is that they can be run on any host, independent of where the database server resides.

Table of Contents
clusterdb  -- cluster a PostgreSQL database
createdb  -- create a new PostgreSQL database
createlang  -- define a new PostgreSQL procedural language
createuser  -- define a new PostgreSQL user account
dropdb  -- remove a PostgreSQL database
droplang  -- remove a PostgreSQL procedural language
dropuser  -- remove a PostgreSQL user account
ecpg  -- embedded SQL C preprocessor
pg_config -- retrieve information about the installed version of PostgreSQL
pg_dump --  extract a PostgreSQL database into a script file or other archive file
pg_dumpall  -- extract a PostgreSQL database cluster into a script file
pg_restore --  restore a PostgreSQL database from an archive file created by pg_dump
psql  --  PostgreSQL interactive terminal
reindexdb  -- reindex a PostgreSQL database
vacuumdb  -- garbage-collect and analyze a PostgreSQL database

 
 
  Published courtesy of The PostgreSQL Global Development Group Design by Interspire