I386LINUX/util/I386LINUX/doc/postgresql/html/reference-client.html

   1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
   2 <HTML
   3 ><HEAD
   4 ><TITLE
   5 >PostgreSQL Client Applications</TITLE
   6 ><META
   7 NAME="GENERATOR"
   8 CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK
   9 REV="MADE"
  10 HREF="mailto:pgsql-docs@postgresql.org"><LINK
  11 REL="HOME"
  12 TITLE="PostgreSQL 7.4.1 Documentation"
  13 HREF="index.html"><LINK
  14 REL="UP"
  15 TITLE="Reference"
  16 HREF="reference.html"><LINK
  17 REL="PREVIOUS"
  18 TITLE="VACUUM"
  19 HREF="sql-vacuum.html"><LINK
  20 REL="NEXT"
  21 TITLE="clusterdb"
  22 HREF="app-clusterdb.html"><LINK
  23 REL="STYLESHEET"
  24 TYPE="text/css"
  25 HREF="stylesheet.css"><META
  26 NAME="creation"
  27 CONTENT="2003-12-22T03:48:47"></HEAD
  28 ><BODY
  29 CLASS="REFERENCE"
  30 ><DIV
  31 CLASS="NAVHEADER"
  32 ><TABLE
  33 SUMMARY="Header navigation table"
  34 WIDTH="100%"
  35 BORDER="0"
  36 CELLPADDING="0"
  37 CELLSPACING="0"
  38 ><TR
  39 ><TH
  40 COLSPAN="5"
  41 ALIGN="center"
  42 VALIGN="bottom"
  43 >PostgreSQL 7.4.1 Documentation</TH
  44 ></TR
  45 ><TR
  46 ><TD
  47 WIDTH="10%"
  48 ALIGN="left"
  49 VALIGN="top"
  50 ><A
  51 HREF="sql-vacuum.html"
  52 ACCESSKEY="P"
  53 >Prev</A
  54 ></TD
  55 ><TD
  56 WIDTH="10%"
  57 ALIGN="left"
  58 VALIGN="top"
  59 ><A
  60 HREF="sql-commands.html"
  61 >Fast Backward</A
  62 ></TD
  63 ><TD
  64 WIDTH="60%"
  65 ALIGN="center"
  66 VALIGN="bottom"
  67 ></TD
  68 ><TD
  69 WIDTH="10%"
  70 ALIGN="right"
  71 VALIGN="top"
  72 ><A
  73 HREF="reference-server.html"
  74 >Fast Forward</A
  75 ></TD
  76 ><TD
  77 WIDTH="10%"
  78 ALIGN="right"
  79 VALIGN="top"
  80 ><A
  81 HREF="app-clusterdb.html"
  82 ACCESSKEY="N"
  83 >Next</A
  84 ></TD
  85 ></TR
  86 ></TABLE
  87 ><HR
  88 ALIGN="LEFT"
  89 WIDTH="100%"></DIV
  90 ><DIV
  91 CLASS="REFERENCE"
  92 ><A
  93 NAME="REFERENCE-CLIENT"
  94 ></A
  95 ><DIV
  96 CLASS="TITLEPAGE"
  97 ><H1
  98 CLASS="TITLE"
  99 >II. PostgreSQL Client Applications</H1
 100 ><DIV
 101 CLASS="PARTINTRO"
 102 ><A
 103 NAME="AEN43043"
 104 ></A
 105 ><P
 106 >    This part contains reference information for
 107     <SPAN
 108 CLASS="PRODUCTNAME"
 109 >PostgreSQL</SPAN
 110 > client applications and
 111     utilities.  Not all of these commands are of general utility, some
 112     may require special privileges.  The common feature of these
 113     applications is that they can be run on any host, independent of
 114     where the database server resides.
 115    </P
 116 ></DIV
 117 ><DIV
 118 CLASS="TOC"
 119 ><DL
 120 ><DT
 121 ><B
 122 >Table of Contents</B
 123 ></DT
 124 ><DT
 125 ><A
 126 HREF="app-clusterdb.html"
 127 ><SPAN
 128 CLASS="APPLICATION"
 129 >clusterdb</SPAN
 130 ></A
 131 >&nbsp;--&nbsp;cluster a <SPAN
 132 CLASS="PRODUCTNAME"
 133 >PostgreSQL</SPAN
 134 > database</DT
 135 ><DT
 136 ><A
 137 HREF="app-createdb.html"
 138 ><SPAN
 139 CLASS="APPLICATION"
 140 >createdb</SPAN
 141 ></A
 142 >&nbsp;--&nbsp;create a new <SPAN
 143 CLASS="PRODUCTNAME"
 144 >PostgreSQL</SPAN
 145 > database</DT
 146 ><DT
 147 ><A
 148 HREF="app-createlang.html"
 149 ><SPAN
 150 CLASS="APPLICATION"
 151 >createlang</SPAN
 152 ></A
 153 >&nbsp;--&nbsp;define a new <SPAN
 154 CLASS="PRODUCTNAME"
 155 >PostgreSQL</SPAN
 156 > procedural language</DT
 157 ><DT
 158 ><A
 159 HREF="app-createuser.html"
 160 ><SPAN
 161 CLASS="APPLICATION"
 162 >createuser</SPAN
 163 ></A
 164 >&nbsp;--&nbsp;define a new <SPAN
 165 CLASS="PRODUCTNAME"
 166 >PostgreSQL</SPAN
 167 > user account</DT
 168 ><DT
 169 ><A
 170 HREF="app-dropdb.html"
 171 ><SPAN
 172 CLASS="APPLICATION"
 173 >dropdb</SPAN
 174 ></A
 175 >&nbsp;--&nbsp;remove a <SPAN
 176 CLASS="PRODUCTNAME"
 177 >PostgreSQL</SPAN
 178 > database</DT
 179 ><DT
 180 ><A
 181 HREF="app-droplang.html"
 182 ><SPAN
 183 CLASS="APPLICATION"
 184 >droplang</SPAN
 185 ></A
 186 >&nbsp;--&nbsp;remove a <SPAN
 187 CLASS="PRODUCTNAME"
 188 >PostgreSQL</SPAN
 189 > procedural language</DT
 190 ><DT
 191 ><A
 192 HREF="app-dropuser.html"
 193 ><SPAN
 194 CLASS="APPLICATION"
 195 >dropuser</SPAN
 196 ></A
 197 >&nbsp;--&nbsp;remove a <SPAN
 198 CLASS="PRODUCTNAME"
 199 >PostgreSQL</SPAN
 200 > user account</DT
 201 ><DT
 202 ><A
 203 HREF="app-ecpg.html"
 204 ><SPAN
 205 CLASS="APPLICATION"
 206 >ecpg</SPAN
 207 ></A
 208 >&nbsp;--&nbsp;embedded SQL C preprocessor</DT
 209 ><DT
 210 ><A
 211 HREF="app-pgconfig.html"
 212 >pg_config</A
 213 >&nbsp;--&nbsp;retrieve information about the installed version of <SPAN
 214 CLASS="PRODUCTNAME"
 215 >PostgreSQL</SPAN
 216 ></DT
 217 ><DT
 218 ><A
 219 HREF="app-pgdump.html"
 220 >pg_dump</A
 221 >&nbsp;--&nbsp;   extract a <SPAN
 222 CLASS="PRODUCTNAME"
 223 >PostgreSQL</SPAN
 224 > database into a script file or other archive file
 225   </DT
 226 ><DT
 227 ><A
 228 HREF="app-pg-dumpall.html"
 229 ><SPAN
 230 CLASS="APPLICATION"
 231 >pg_dumpall</SPAN
 232 ></A
 233 >&nbsp;--&nbsp;extract a <SPAN
 234 CLASS="PRODUCTNAME"
 235 >PostgreSQL</SPAN
 236 > database cluster into a script file</DT
 237 ><DT
 238 ><A
 239 HREF="app-pgrestore.html"
 240 >pg_restore</A
 241 >&nbsp;--&nbsp;   restore a <SPAN
 242 CLASS="PRODUCTNAME"
 243 >PostgreSQL</SPAN
 244 > database from an archive file created by pg_dump
 245   </DT
 246 ><DT
 247 ><A
 248 HREF="app-pgtclsh.html"
 249 >pgtclsh</A
 250 >&nbsp;--&nbsp;   <SPAN
 251 CLASS="PRODUCTNAME"
 252 >PostgreSQL</SPAN
 253 > <SPAN
 254 CLASS="APPLICATION"
 255 >Tcl</SPAN
 256 > shell client
 257   </DT
 258 ><DT
 259 ><A
 260 HREF="app-pgtksh.html"
 261 >pgtksh</A
 262 >&nbsp;--&nbsp;   <SPAN
 263 CLASS="PRODUCTNAME"
 264 >PostgreSQL</SPAN
 265 > <SPAN
 266 CLASS="APPLICATION"
 267 >Tcl/Tk</SPAN
 268 > shell client
 269   </DT
 270 ><DT
 271 ><A
 272 HREF="app-psql.html"
 273 ><SPAN
 274 CLASS="APPLICATION"
 275 >psql</SPAN
 276 ></A
 277 >&nbsp;--&nbsp;      <SPAN
 278 CLASS="PRODUCTNAME"
 279 >PostgreSQL</SPAN
 280 > interactive terminal
 281     </DT
 282 ><DT
 283 ><A
 284 HREF="app-vacuumdb.html"
 285 ><SPAN
 286 CLASS="APPLICATION"
 287 >vacuumdb</SPAN
 288 ></A
 289 >&nbsp;--&nbsp;garbage-collect and analyze a <SPAN
 290 CLASS="PRODUCTNAME"
 291 >PostgreSQL</SPAN
 292 > database</DT
 293 ></DL
 294 ></DIV
 295 ></DIV
 296 ></DIV
 297 ><DIV
 298 CLASS="NAVFOOTER"
 299 ><HR
 300 ALIGN="LEFT"
 301 WIDTH="100%"><TABLE
 302 SUMMARY="Footer navigation table"
 303 WIDTH="100%"
 304 BORDER="0"
 305 CELLPADDING="0"
 306 CELLSPACING="0"
 307 ><TR
 308 ><TD
 309 WIDTH="33%"
 310 ALIGN="left"
 311 VALIGN="top"
 312 ><A
 313 HREF="sql-vacuum.html"
 314 ACCESSKEY="P"
 315 >Prev</A
 316 ></TD
 317 ><TD
 318 WIDTH="34%"
 319 ALIGN="center"
 320 VALIGN="top"
 321 ><A
 322 HREF="index.html"
 323 ACCESSKEY="H"
 324 >Home</A
 325 ></TD
 326 ><TD
 327 WIDTH="33%"
 328 ALIGN="right"
 329 VALIGN="top"
 330 ><A
 331 HREF="app-clusterdb.html"
 332 ACCESSKEY="N"
 333 >Next</A
 334 ></TD
 335 ></TR
 336 ><TR
 337 ><TD
 338 WIDTH="33%"
 339 ALIGN="left"
 340 VALIGN="top"
 341 >VACUUM</TD
 342 ><TD
 343 WIDTH="34%"
 344 ALIGN="center"
 345 VALIGN="top"
 346 ><A
 347 HREF="reference.html"
 348 ACCESSKEY="U"
 349 >Up</A
 350 ></TD
 351 ><TD
 352 WIDTH="33%"
 353 ALIGN="right"
 354 VALIGN="top"
 355 ><SPAN
 356 CLASS="APPLICATION"
 357 >clusterdb</SPAN
 358 ></TD
 359 ></TR
 360 ></TABLE
 361 ></DIV
 362 ></BODY
 363 ></HTML
 364 >