aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat
-rw-r--r--doc/src/sgml/ref/allfiles.sgml6
-rw-r--r--doc/src/sgml/ref/commands.sgml6
-rw-r--r--doc/src/sgml/ref/create_type.sgml4
-rw-r--r--doc/src/sgml/ref/createdb.sgml7
-rw-r--r--doc/src/sgml/ref/createlang.sgml172
-rw-r--r--doc/src/sgml/ref/destroylang.sgml172
-rw-r--r--doc/src/sgml/ref/drop_database.sgml10
-rw-r--r--doc/src/sgml/ref/pgaccess-ref.sgml357
-rw-r--r--doc/src/sgml/ref/pgadmin-ref.sgml4
-rw-r--r--doc/src/sgml/ref/pgtclsh.sgml91
-rw-r--r--doc/src/sgml/ref/pgtksh.sgml91
-rw-r--r--doc/src/sgml/ref/postgres-ref.sgml8
-rw-r--r--doc/src/sgml/ref/postmaster.sgml4
-rw-r--r--doc/src/sgml/ref/select.sgml44
14 files changed, 916 insertions, 60 deletions
diff --git a/doc/src/sgml/ref/allfiles.sgml b/doc/src/sgml/ref/allfiles.sgml
index a0558440d72..50e8c89490d 100644
--- a/doc/src/sgml/ref/allfiles.sgml
+++ b/doc/src/sgml/ref/allfiles.sgml
@@ -1,5 +1,5 @@
<!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/allfiles.sgml,v 1.10 1999/07/22 15:09:06 thomas Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/allfiles.sgml,v 1.11 1999/08/06 13:50:29 thomas Exp $
Postgres documentation
Complete list of usable sgml source files in this directory.
-->
@@ -99,8 +99,10 @@ Complete list of usable sgml source files in this directory.
<!-- these are in the "utilities" reference chapter -->
<!entity createdb system "createdb.sgml">
+<!entity createlang system "createlang.sgml">
<!entity createuser system "createuser.sgml">
<!entity destroydb system "destroydb.sgml">
+<!entity destroylang system "destroylang.sgml">
<!entity destroyuser system "destroyuser.sgml">
<!entity ecpgRef system "ecpg-ref.sgml">
<!entity initdb system "initdb.sgml">
@@ -111,6 +113,8 @@ Complete list of usable sgml source files in this directory.
<!entity pgDump system "pg_dump.sgml">
<!entity pgDumpall system "pg_dumpall.sgml">
<!entity pgPasswd system "pg_passwd.sgml">
+<!entity pgTclSh system "pgtclsh.sgml">
+<!entity pgTkSh system "pgtksh.sgml">
<!entity pgUpgrade system "pg_upgrade.sgml">
<!entity postgres system "postgres-ref.sgml">
<!entity postmaster system "postmaster.sgml">
diff --git a/doc/src/sgml/ref/commands.sgml b/doc/src/sgml/ref/commands.sgml
index 6ed2873c387..bc16b4cf2a9 100644
--- a/doc/src/sgml/ref/commands.sgml
+++ b/doc/src/sgml/ref/commands.sgml
@@ -1,5 +1,5 @@
<!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/Attic/commands.sgml,v 1.17 1999/07/22 15:09:06 thomas Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/Attic/commands.sgml,v 1.18 1999/08/06 13:50:30 thomas Exp $
Postgres documentation
-->
@@ -106,8 +106,10 @@ functions supported by <productname>Postgres</productname>.
</abstract>
&createdb;
+ &createlang;
&createuser;
&destroydb;
+ &destroylang;
&destroyuser;
&ecpgRef;
&pgAccess;
@@ -115,6 +117,8 @@ functions supported by <productname>Postgres</productname>.
&pgDump;
&pgDumpall;
&psqlRef;
+ &pgTclSh;
+ &pgTkSh;
&vacuumdb;
</chapter>
diff --git a/doc/src/sgml/ref/create_type.sgml b/doc/src/sgml/ref/create_type.sgml
index 91a8b7d15da..07c2617bf0b 100644
--- a/doc/src/sgml/ref/create_type.sgml
+++ b/doc/src/sgml/ref/create_type.sgml
@@ -1,11 +1,11 @@
<!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_type.sgml,v 1.10 1999/07/22 15:09:08 thomas Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_type.sgml,v 1.11 1999/08/06 13:50:30 thomas Exp $
Postgres documentation
-->
<refentry id="SQL-CREATETYPE">
<refmeta>
- <refentrytitle>
+ <refentrytitle id="sql-createtype-title">
CREATE TYPE
</refentrytitle>
<refmiscinfo>SQL - Language Statements</refmiscinfo>
diff --git a/doc/src/sgml/ref/createdb.sgml b/doc/src/sgml/ref/createdb.sgml
index 906e2dbf6e4..8d36e805d63 100644
--- a/doc/src/sgml/ref/createdb.sgml
+++ b/doc/src/sgml/ref/createdb.sgml
@@ -1,9 +1,9 @@
<!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/createdb.sgml,v 1.5 1999/07/22 15:09:09 thomas Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/createdb.sgml,v 1.6 1999/08/06 13:50:30 thomas Exp $
Postgres documentation
-->
-<refentry id="APP-CREATEDB">
+<refentry id="APP-CREATEDB" xreflabel="createdb">
<refmeta>
<refentrytitle id="APP-CREATEDB-TITLE">
<application>createdb</application>
@@ -229,7 +229,8 @@ createdb: database creation failed on <replaceable class="parameter">dbname</rep
<envar>PGREALM</envar>
environment variables will be passed on to
<application>psql</application>
- and processed as described in <xref endterm="app-psql-title" linkend="app-psql-title">.
+ and processed as described in
+ <xref linkend="app-psql-title" endterm="app-psql-title">.
</para>
</refsect1>
diff --git a/doc/src/sgml/ref/createlang.sgml b/doc/src/sgml/ref/createlang.sgml
new file mode 100644
index 00000000000..8da1cdaa1e8
--- /dev/null
+++ b/doc/src/sgml/ref/createlang.sgml
@@ -0,0 +1,172 @@
+<!--
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/createlang.sgml,v 1.1 1999/08/06 13:50:30 thomas Exp $
+Postgres documentation
+-->
+
+<refentry id="APP-CREATELANG">
+ <refmeta>
+ <refentrytitle id="APP-CREATELANG-TITLE">
+ <application>createlang</application>
+ </refentrytitle>
+ <refmiscinfo>Application</refmiscinfo>
+ </refmeta>
+ <refnamediv>
+ <refname id="createlang">
+ <application>createlang</application>
+ </refname>
+ <refpurpose>
+ Add a new programming language to a <productname>Postgres</productname> database
+ </refpurpose>
+ </refnamediv>
+ <refsynopsisdiv>
+ <refsynopsisdivinfo>
+ <date>1999-08-05</date>
+ </refsynopsisdivinfo>
+ <synopsis>
+createlang [ <replaceable class="parameter">langname</replaceable> ]
+createlang [ -h <replaceable class="parameter">host</replaceable> ] [ -p <replaceable class="parameter">port</replaceable> ]
+ [ <replaceable class="parameter">langname</replaceable> ]
+ </synopsis>
+
+ <refsect2 id="R2-APP-CREATELANG-1">
+ <title>
+ Inputs
+ </title>
+ <para>
+ <application>createlang</application> accepts the following command line arguments:
+
+ <variablelist>
+ <varlistentry>
+ <term><replaceable class="parameter">langname</replaceable></term>
+ <listitem>
+ <para>
+ Specifies the name of the backend programming language to be defined.
+ <application>createlang</application> will prompt for
+ <replaceable class="parameter">langname</replaceable>
+ if it is not specified on the command line.
+ </para>
+ </listitem>
+ </varlistentry>
+ </variablelist>
+ </para>
+
+ <para>
+ <application>createlang</application> also accepts
+ the following command line arguments for connection parameters:
+
+ <variablelist>
+ <varlistentry>
+ <term>-h <replaceable class="parameter">host</replaceable></term>
+ <listitem>
+ <para>
+ Specifies the hostname of the machine on which the
+ <application>postmaster</application>
+ is running. Defaults to using a local Unix domain socket
+ rather than an IP connection.
+ </para>
+ </listitem>
+ </varlistentry>
+
+ <varlistentry>
+ <term>-p <replaceable class="parameter">port</replaceable></term>
+ <listitem>
+ <para>
+ Specifies the Internet TCP/IP port or local Unix domain socket file
+ extension on which the <application>postmaster</application>
+ is listening for connections. The port number defaults to 5432,
+ or the value of the <envar>PGPORT</envar>
+ environment variable (if set).
+ </para>
+ </listitem>
+ </varlistentry>
+ <!--
+ <varlistentry>
+ <term>-u</term>
+ <listitem>
+ <para>
+ Use password authentication.
+ Prompts for
+ <replaceable class="parameter">username</replaceable>
+ and <replaceable class="parameter">password</replaceable>.
+ </para>
+ </listitem>
+ </varlistentry>
+ -->
+ </variablelist>
+ </para>
+ </refsect2>
+
+ <refsect2 id="R2-APP-CREATELANG-2">
+ <refsect2info>
+ <date>1998-10-04</date>
+ </refsect2info>
+ <title>
+ Outputs
+ </title>
+ <para>
+ <application>createlang</application> installs a new programming
+ language into a <productname>Postgres</productname> server,
+ so has not explicit external output.
+ </para>
+ </refsect2>
+ </refsynopsisdiv>
+
+ <refsect1 id="R1-APP-CREATELANG-1">
+ <refsect1info>
+ <date>1998-10-04</date>
+ </refsect1info>
+ <title>
+ Description
+ </title>
+
+ <para>
+ <application>createlang</application> is a utility for adding a new
+ programming language to a
+ <productname>Postgres</productname> database.
+ <application>createlang</application> currently accepts two
+ languages, <literal>plsql</literal> and <literal>pltcl</literal>.
+ </para>
+ </refsect1>
+
+ <refsect1 id="R1-APP-CREATELANG-2">
+ <title>
+ Notes
+ </title>
+
+ <para>
+ See
+ <xref linkend="sql-createlanguage" endterm="sql-createlanguage-title">
+ for more details.
+ </para>
+ </refsect1>
+
+ <refsect1 id="R1-APP-CREATELANG-3">
+ <title>
+ Usage
+ </title>
+ <para>
+ To install <literal>pltcl</literal>:
+
+ <programlisting>
+% createlang pltcl
+ </programlisting>
+ </para>
+ </refsect1>
+</refentry>
+
+<!-- Keep this comment at the end of the file
+Local variables:
+mode: sgml
+sgml-omittag:nil
+sgml-shorttag:t
+sgml-minimize-attributes:nil
+sgml-always-quote-attributes:t
+sgml-indent-step:1
+sgml-indent-data:t
+sgml-parent-document:nil
+sgml-default-dtd-file:"../reference.ced"
+sgml-exposed-tags:nil
+sgml-local-catalogs:"/usr/lib/sgml/catalog"
+sgml-local-ecat-files:nil
+End:
+-->
diff --git a/doc/src/sgml/ref/destroylang.sgml b/doc/src/sgml/ref/destroylang.sgml
new file mode 100644
index 00000000000..3b307142483
--- /dev/null
+++ b/doc/src/sgml/ref/destroylang.sgml
@@ -0,0 +1,172 @@
+<!--
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/Attic/destroylang.sgml,v 1.1 1999/08/06 13:50:30 thomas Exp $
+Postgres documentation
+-->
+
+<refentry id="APP-DESTROYLANG">
+ <refmeta>
+ <refentrytitle id="APP-DESTROYLANG-TITLE">
+ <application>destroylang</application>
+ </refentrytitle>
+ <refmiscinfo>Application</refmiscinfo>
+ </refmeta>
+ <refnamediv>
+ <refname id="destroylang">
+ <application>destroylang</application>
+ </refname>
+ <refpurpose>
+ Add a programming language to a <productname>Postgres</productname> database
+ </refpurpose>
+ </refnamediv>
+ <refsynopsisdiv>
+ <refsynopsisdivinfo>
+ <date>1999-08-05</date>
+ </refsynopsisdivinfo>
+ <synopsis>
+destroylang [ <replaceable class="parameter">langname</replaceable> ]
+destroylang [ -h <replaceable class="parameter">host</replaceable> ] [ -p <replaceable class="parameter">port</replaceable> ]
+ [ <replaceable class="parameter">langname</replaceable> ]
+ </synopsis>
+
+ <refsect2 id="R2-APP-DESTROYLANG-1">
+ <title>
+ Inputs
+ </title>
+ <para>
+ <application>destroylang</application> accepts the following command line arguments:
+
+ <variablelist>
+ <varlistentry>
+ <term><replaceable class="parameter">langname</replaceable></term>
+ <listitem>
+ <para>
+ Specifies the name of the backend programming language to be destroyed.
+ <application>destroylang</application> will prompt for
+ <replaceable class="parameter">langname</replaceable>
+ if it is not specified on the command line.
+ </para>
+ </listitem>
+ </varlistentry>
+ </variablelist>
+ </para>
+
+ <para>
+ <application>destroylang</application> also accepts
+ the following command line arguments for connection parameters:
+
+ <variablelist>
+ <varlistentry>
+ <term>-h <replaceable class="parameter">host</replaceable></term>
+ <listitem>
+ <para>
+ Specifies the hostname of the machine on which the
+ <application>postmaster</application>
+ is running. Defaults to using a local Unix domain socket
+ rather than an IP connection.
+ </para>
+ </listitem>
+ </varlistentry>
+
+ <varlistentry>
+ <term>-p <replaceable class="parameter">port</replaceable></term>
+ <listitem>
+ <para>
+ Specifies the Internet TCP/IP port or local Unix domain socket file
+ extension on which the <application>postmaster</application>
+ is listening for connections. The port number defaults to 5432,
+ or the value of the <envar>PGPORT</envar>
+ environment variable (if set).
+ </para>
+ </listitem>
+ </varlistentry>
+ <!--
+ <varlistentry>
+ <term>-u</term>
+ <listitem>
+ <para>
+ Use password authentication.
+ Prompts for
+ <replaceable class="parameter">username</replaceable>
+ and <replaceable class="parameter">password</replaceable>.
+ </para>
+ </listitem>
+ </varlistentry>
+ -->
+ </variablelist>
+ </para>
+ </refsect2>
+
+ <refsect2 id="R2-APP-DESTROYLANG-2">
+ <refsect2info>
+ <date>1998-10-04</date>
+ </refsect2info>
+ <title>
+ Outputs
+ </title>
+ <para>
+ <application>destroylang</application> removes an existing programming
+ language from a <productname>Postgres</productname> server,
+ so has not explicit external output.
+ </para>
+ </refsect2>
+ </refsynopsisdiv>
+
+ <refsect1 id="R1-APP-DESTROYLANG-1">
+ <refsect1info>
+ <date>1998-10-04</date>
+ </refsect1info>
+ <title>
+ Description
+ </title>
+
+ <para>
+ <application>destroylang</application> is a utility for removing an
+ existing programming language from a
+ <productname>Postgres</productname> database.
+ <application>destroylang</application> currently accepts two
+ languages, <literal>plsql</literal> and <literal>pltcl</literal>.
+ </para>
+ </refsect1>
+
+ <refsect1 id="R1-APP-DESTROYLANG-2">
+ <title>
+ Notes
+ </title>
+
+ <para>
+ See
+ <xref linkend="sql-droplanguage" endterm="sql-droplanguage-title">
+ for more details.
+ </para>
+ </refsect1>
+
+ <refsect1 id="R1-APP-DESTROYLANG-3">
+ <title>
+ Usage
+ </title>
+ <para>
+ To remove <literal>pltcl</literal>:
+
+ <programlisting>
+% destroylang pltcl
+ </programlisting>
+ </para>
+ </refsect1>
+</refentry>
+
+<!-- Keep this comment at the end of the file
+Local variables:
+mode: sgml
+sgml-omittag:nil
+sgml-shorttag:t
+sgml-minimize-attributes:nil
+sgml-always-quote-attributes:t
+sgml-indent-step:1
+sgml-indent-data:t
+sgml-parent-document:nil
+sgml-default-dtd-file:"../reference.ced"
+sgml-exposed-tags:nil
+sgml-local-catalogs:"/usr/lib/sgml/catalog"
+sgml-local-ecat-files:nil
+End:
+-->
diff --git a/doc/src/sgml/ref/drop_database.sgml b/doc/src/sgml/ref/drop_database.sgml
index a60cd7f5f69..0dc1db2a614 100644
--- a/doc/src/sgml/ref/drop_database.sgml
+++ b/doc/src/sgml/ref/drop_database.sgml
@@ -1,9 +1,9 @@
<!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_database.sgml,v 1.6 1999/07/22 15:09:10 thomas Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_database.sgml,v 1.7 1999/08/06 13:50:30 thomas Exp $
Postgres documentation
-->
-<refentry id="SQL-DROPDATABASE">
+<refentry id="SQL-DROPDATABASE" xreflabel="drop_database">
<refmeta>
<refentrytitle id="SQL-DROPDATABASE-TITLE">
DROP DATABASE
@@ -117,14 +117,14 @@ WARN: destroydb: database "<replaceable class="parameter">name</replaceable>" do
<para>
This query cannot be executed while connected to the target
database. It is usually preferable to use
- <xref linkend="app-destroydb-title" endterm="app-destroydb-title">
+ <xref linkend="app-destroydb" endterm="app-destroydb-title">
instead.
</para>
<para>
Refer to
- <xref linkend="app-createdb-title" endterm="app-createdb-title"> and
- <xref linkend="sql-createdatabase-title" endterm="sql-createdatabase-title">
+ <xref linkend="app-createdb" endterm="app-createdb-title"> and
+ <xref linkend="sql-createdatabase" endterm="sql-createdatabase-title">
for information on how to create a database.
</para>
</refsect2>
diff --git a/doc/src/sgml/ref/pgaccess-ref.sgml b/doc/src/sgml/ref/pgaccess-ref.sgml
index 469f8100f58..7fc553fea70 100644
--- a/doc/src/sgml/ref/pgaccess-ref.sgml
+++ b/doc/src/sgml/ref/pgaccess-ref.sgml
@@ -1,11 +1,11 @@
<!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/Attic/pgaccess-ref.sgml,v 1.3 1999/07/22 15:09:14 thomas Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/Attic/pgaccess-ref.sgml,v 1.4 1999/08/06 13:50:30 thomas Exp $
Postgres documentation
-->
<refentry id="APP-PGACCESS">
<refmeta>
- <refentrytitle id="pgaccess-ref">
+ <refentrytitle id="app-pgaccess-title">
<application>pgaccess</application>
</refentrytitle>
<refmiscinfo>Application</refmiscinfo>
@@ -20,16 +20,13 @@ Postgres documentation
</refnamediv>
<refsynopsisdiv>
<refsynopsisdivinfo>
- <date>1999-05-19</date>
+ <date>1999-08-03</date>
</refsynopsisdivinfo>
<synopsis>
pgaccess [ <replaceable class="parameter">dbname</replaceable> ]
</synopsis>
<refsect2 id="R2-APP-PGACCESS-1">
- <refsect2info>
- <date>1999-05-19</date>
- </refsect2info>
<title>
Inputs
</title>
@@ -49,9 +46,6 @@ pgaccess [ <replaceable class="parameter">dbname</replaceable> ]
</refsect2>
<refsect2 id="R2-APP-PGACCESS-2">
- <refsect2info>
- <date>1999-05-19</date>
- </refsect2info>
<title>
Outputs
</title>
@@ -61,19 +55,346 @@ pgaccess [ <replaceable class="parameter">dbname</replaceable> ]
</refsynopsisdiv>
<refsect1 id="R1-APP-PGACCESS-1">
- <refsect1info>
- <date>1999-05-19</date>
- </refsect1info>
<title>
Description
</title>
<para>
- <note>
- <title>Editor's Note</title>
- <para>
- This should be transcribed from other pgaccess info. Volunteers?
- </para>
- </note>
+ <application>pgaccess</application> provides a graphical interface
+ for <productname>Postgres</productname>
+ where you
+ can manage your tables, edit them, define queries, sequences and
+ functions.
+ </para>
+
+ <para>
+ Another way of accessing <productname>Postgres</productname>
+ through tcl is to use
+ <xref linkend="app-pgtclsh" endterm="app-pgtclsh-title">
+ or
+ <xref linkend="app-pgtksh" endterm="app-pgtksh-title">.
+ </para>
+
+ <para>
+ <application>pgaccess</application> can:
+
+ <itemizedlist mark="bullet" spacing="compact">
+ <listitem>
+ <para>
+ Opens any database on a specified host at the specified port,
+ username and password.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Execute <xref linkend="sql-vacuum" endterm="sql-vacuum-title">.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Saves preferences in <filename>~/.pgaccessrc</filename> file.
+ </para>
+ </listitem>
+ </itemizedlist>
+ </para>
+
+ <para>
+ For tables, <application>pgaccess</application> can:
+
+ <itemizedlist mark="bullet" spacing="compact">
+ <listitem>
+ <para>
+ Open multiple tables for viewing, max n records (configurable).
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Resize columns by dragging the vertical grid lines.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Wrap text in cells.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Dynamically adjust row height when editing.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Save table layout for every table.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Import/export to external files (SDF,CSV).
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Use filter capabilities; enter filter like price>3.14.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Specify sort order; enter manually the sort field(s).
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Edit in place; double click the text you want to change.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Delete records; point to the record, press Del key.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Add new records; save new row with right-button-click.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Create tables with an assistant.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Rename and delete (drop) tables.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Retrieve information on tables, including owner, field information, indices.
+ </para>
+ </listitem>
+ </itemizedlist>
+ </para>
+
+ <para>
+ For queries, <application>pgaccess</application> can:
+
+ <itemizedlist mark="bullet" spacing="compact">
+ <listitem>
+ <para>
+ Define, edit and store <firstterm>user defined queries</firstterm>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Save view layouts.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Store queries as views.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Execute with optional user input parameters; e.g.
+ <programlisting>
+select * from invoices where year=[parameter "Year of selection"]
+ </programlisting>
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ View any select query result.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Run action queries (insert, update, delete).
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Construct queries using a visual query builder
+ with drag & drop support, table aliasing.
+ </para>
+ </listitem>
+ </itemizedlist>
+ </para>
+
+ <para>
+ For sequences, <application>pgaccess</application> can:
+
+ <itemizedlist mark="bullet" spacing="compact">
+ <listitem>
+ <para>
+ Define new instances.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Inspect existing instances.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Delete.
+ </para>
+ </listitem>
+ </itemizedlist>
+ </para>
+
+ <para>
+ For views, <application>pgaccess</application> can:
+
+ <itemizedlist mark="bullet" spacing="compact">
+ <listitem>
+ <para>
+ Define them by saving queries as views.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ View them, with filtering and sorting capabilities.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Design new views.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Delete (drop) existing views.
+ </para>
+ </listitem>
+ </itemizedlist>
+ </para>
+
+ <para>
+ For functions, <application>pgaccess</application> can:
+
+ <itemizedlist mark="bullet" spacing="compact">
+ <listitem>
+ <para>
+ Define.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Inspect.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Delete.
+ </para>
+ </listitem>
+ </itemizedlist>
+ </para>
+
+ <para>
+ For reports, <application>pgaccess</application> can:
+
+ <itemizedlist mark="bullet" spacing="compact">
+ <listitem>
+ <para>
+ Generate simple reports from a table (beta stage).
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Change font, size and style of fields and labels.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Load and save reports from the database.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Preview tables, sample postscript print.
+ </para>
+ </listitem>
+ </itemizedlist>
+ </para>
+
+ <para>
+ For forms, <application>pgaccess</application> can:
+
+ <itemizedlist mark="bullet" spacing="compact">
+ <listitem>
+ <para>
+ Open user defined forms.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Use a form design module.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Access record sets using a query widget.
+ </para>
+ </listitem>
+ </itemizedlist>
+ </para>
+
+ <para>
+ For scripts, <application>pgaccess</application> can:
+
+ <itemizedlist mark="bullet" spacing="compact">
+ <listitem>
+ <para>
+ Define.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Modify.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Call user defined scripts.
+ </para>
+ </listitem>
+ </itemizedlist>
</para>
</refsect1>
</refentry>
diff --git a/doc/src/sgml/ref/pgadmin-ref.sgml b/doc/src/sgml/ref/pgadmin-ref.sgml
index 1ffd7056732..2fa53745ef7 100644
--- a/doc/src/sgml/ref/pgadmin-ref.sgml
+++ b/doc/src/sgml/ref/pgadmin-ref.sgml
@@ -1,11 +1,11 @@
<!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/Attic/pgadmin-ref.sgml,v 1.3 1999/07/22 15:09:14 thomas Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/Attic/pgadmin-ref.sgml,v 1.4 1999/08/06 13:50:31 thomas Exp $
Postgres documentation
-->
<refentry id="APP-PGADMIN">
<refmeta>
- <refentrytitle id="pgadmin-ref">
+ <refentrytitle id="app-pgadmin-title">
<application>pgadmin</application>
</refentrytitle>
<refmiscinfo>Application</refmiscinfo>
diff --git a/doc/src/sgml/ref/pgtclsh.sgml b/doc/src/sgml/ref/pgtclsh.sgml
new file mode 100644
index 00000000000..ac947ed3b3a
--- /dev/null
+++ b/doc/src/sgml/ref/pgtclsh.sgml
@@ -0,0 +1,91 @@
+<!--
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/Attic/pgtclsh.sgml,v 1.1 1999/08/06 13:50:31 thomas Exp $
+Postgres documentation
+-->
+
+<refentry id="APP-PGTCLSH">
+ <refmeta>
+ <refentrytitle id="app-pgtclsh-title">
+ <application>pgtclsh</application>
+ </refentrytitle>
+ <refmiscinfo>Application</refmiscinfo>
+ </refmeta>
+ <refnamediv>
+ <refname>
+ <application>pgtclsh</application>
+ </refname>
+ <refpurpose>
+ <productname>Postgres</productname> TCL shell client
+ </refpurpose>
+ </refnamediv>
+ <refsynopsisdiv>
+ <refsynopsisdivinfo>
+ <date>1999-08-03</date>
+ </refsynopsisdivinfo>
+ <synopsis>
+pgtclsh [ <replaceable class="parameter">dbname</replaceable> ]
+ </synopsis>
+
+ <refsect2 id="R2-APP-PGTCLSH-1">
+ <title>
+ Inputs
+ </title>
+ <para>
+
+ <variablelist>
+ <varlistentry>
+ <term><replaceable class="PARAMETER">dbname</replaceable></term>
+ <listitem>
+ <para>
+ The name of an existing database to access.
+ </para>
+ </listitem>
+ </varlistentry>
+ </variablelist>
+ </para>
+ </refsect2>
+
+ <refsect2 id="R2-APP-PGTCLSH-2">
+ <title>
+ Outputs
+ </title>
+ <para>
+ </para>
+ </refsect2>
+ </refsynopsisdiv>
+
+ <refsect1 id="R1-APP-PGTCLSH-1">
+ <title>
+ Description
+ </title>
+ <para>
+ <application>pgtclsh</application> provides a TCL shell interface
+ for <productname>Postgres</productname>.
+ </para>
+
+ <para>
+ Another way of accessing <productname>Postgres</productname>
+ through tcl is to use
+ <xref linkend="app-pgtksh" endterm="app-pgtksh-title">
+ or
+ <xref linkend="app-pgaccess" endterm="app-pgaccess-title">.
+ </para>
+ </refsect1>
+</refentry>
+
+<!-- Keep this comment at the end of the file
+Local variables:
+mode: sgml
+sgml-omittag:nil
+sgml-shorttag:t
+sgml-minimize-attributes:nil
+sgml-always-quote-attributes:t
+sgml-indent-step:1
+sgml-indent-data:t
+sgml-parent-document:nil
+sgml-default-dtd-file:"../reference.ced"
+sgml-exposed-tags:nil
+sgml-local-catalogs:"/usr/lib/sgml/catalog"
+sgml-local-ecat-files:nil
+End:
+-->
diff --git a/doc/src/sgml/ref/pgtksh.sgml b/doc/src/sgml/ref/pgtksh.sgml
new file mode 100644
index 00000000000..9900225f04e
--- /dev/null
+++ b/doc/src/sgml/ref/pgtksh.sgml
@@ -0,0 +1,91 @@
+<!--
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/Attic/pgtksh.sgml,v 1.1 1999/08/06 13:50:31 thomas Exp $
+Postgres documentation
+-->
+
+<refentry id="APP-PGTKSH">
+ <refmeta>
+ <refentrytitle id="app-pgtksh-title">
+ <application>pgtksh</application>
+ </refentrytitle>
+ <refmiscinfo>Application</refmiscinfo>
+ </refmeta>
+ <refnamediv>
+ <refname>
+ <application>pgtksh</application>
+ </refname>
+ <refpurpose>
+ <productname>Postgres</productname> graphical TCL/TK shell
+ </refpurpose>
+ </refnamediv>
+ <refsynopsisdiv>
+ <refsynopsisdivinfo>
+ <date>1999-08-03</date>
+ </refsynopsisdivinfo>
+ <synopsis>
+pgtksh [ <replaceable class="parameter">dbname</replaceable> ]
+ </synopsis>
+
+ <refsect2 id="R2-APP-PGTKSH-1">
+ <title>
+ Inputs
+ </title>
+ <para>
+
+ <variablelist>
+ <varlistentry>
+ <term><replaceable class="PARAMETER">dbname</replaceable></term>
+ <listitem>
+ <para>
+ The name of an existing database to access.
+ </para>
+ </listitem>
+ </varlistentry>
+ </variablelist>
+ </para>
+ </refsect2>
+
+ <refsect2 id="R2-APP-PGTKSH-2">
+ <title>
+ Outputs
+ </title>
+ <para>
+ </para>
+ </refsect2>
+ </refsynopsisdiv>
+
+ <refsect1 id="R1-APP-PGTKSH-1">
+ <title>
+ Description
+ </title>
+ <para>
+ <application>pgtksh</application> provides a graphical TCL/TK shell interface
+ for <productname>Postgres</productname>.
+ </para>
+
+ <para>
+ Another way of accessing <productname>Postgres</productname>
+ through <acronym>TCL</acronym> is to use
+ <xref linkend="app-pgtclsh" endterm="app-pgtclsh-title">
+ or
+ <xref linkend="app-pgaccess" endterm="app-pgaccess-title">.
+ </para>
+ </refsect1>
+</refentry>
+
+<!-- Keep this comment at the end of the file
+Local variables:
+mode: sgml
+sgml-omittag:nil
+sgml-shorttag:t
+sgml-minimize-attributes:nil
+sgml-always-quote-attributes:t
+sgml-indent-step:1
+sgml-indent-data:t
+sgml-parent-document:nil
+sgml-default-dtd-file:"../reference.ced"
+sgml-exposed-tags:nil
+sgml-local-catalogs:"/usr/lib/sgml/catalog"
+sgml-local-ecat-files:nil
+End:
+-->
diff --git a/doc/src/sgml/ref/postgres-ref.sgml b/doc/src/sgml/ref/postgres-ref.sgml
index add30e27e42..96f9e64644d 100644
--- a/doc/src/sgml/ref/postgres-ref.sgml
+++ b/doc/src/sgml/ref/postgres-ref.sgml
@@ -1,5 +1,5 @@
<!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/postgres-ref.sgml,v 1.5 1999/07/22 15:09:14 thomas Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/postgres-ref.sgml,v 1.6 1999/08/06 13:50:31 thomas Exp $
Postgres documentation
-->
@@ -11,7 +11,7 @@ Postgres documentation
<refmiscinfo>Application</refmiscinfo>
</refmeta>
<refnamediv>
- <refname id="postgres-ref">
+ <refname>
<application>postgres</application>
</refname>
<refpurpose>
@@ -190,7 +190,7 @@ postgres [ -B <replaceable class="parameter">nBuffers</replaceable> ] [ -C ] [ -
Dates are accepted by the backend in a wide variety of formats,
and for input dates this switch mostly affects the interpretation
for ambiguous cases.
- See <xref linkend="datatype-title" endterm="datatype-title">
+ See <citetitle>The PostgreSQL User's Guide</citetitle>
for more information.
</para>
</listitem>
@@ -420,7 +420,7 @@ semget: No space left on device
<application>ipcs(1)</application>,
<application>ipcrm(1</application>), and
<application>ipcclean(1)</application>.
- See also <xref linkend="postmaster-ref" endterm="postmaster-ref">.
+ See also <xref linkend="app-postmaster" endterm="app-postmaster-title">.
</para>
</refsect1>
</refentry>
diff --git a/doc/src/sgml/ref/postmaster.sgml b/doc/src/sgml/ref/postmaster.sgml
index 7b249d17e23..e3587d30973 100644
--- a/doc/src/sgml/ref/postmaster.sgml
+++ b/doc/src/sgml/ref/postmaster.sgml
@@ -1,5 +1,5 @@
<!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/postmaster.sgml,v 1.4 1999/07/22 15:09:14 thomas Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/postmaster.sgml,v 1.5 1999/08/06 13:50:31 thomas Exp $
Postgres documentation
-->
@@ -460,7 +460,7 @@ or its alternative form
<programlisting>
% setenv PGPORT 1234
% psql
- </programlisting>.
+ </programlisting>
</para>
</refsect1>
</refentry>
diff --git a/doc/src/sgml/ref/select.sgml b/doc/src/sgml/ref/select.sgml
index 0e17cc1c8b3..f2afa38b7c9 100644
--- a/doc/src/sgml/ref/select.sgml
+++ b/doc/src/sgml/ref/select.sgml
@@ -1,5 +1,5 @@
<!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/select.sgml,v 1.21 1999/07/22 15:09:14 thomas Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/select.sgml,v 1.22 1999/08/06 13:50:31 thomas Exp $
Postgres documentation
-->
@@ -197,7 +197,7 @@ SELECT [ ALL | DISTINCT [ ON <replaceable class="PARAMETER">column</replaceable>
<command>SELECT</command> will return rows from one or more tables.
Candidates for selection are rows which satisfy the WHERE condition;
if WHERE is omitted, all rows are candidates.
- (See <xref linkend="where-title" endterm="where-title">.)
+ (See <xref linkend="sql-where" endterm="sql-where-title">.)
</para>
<para>
@@ -214,37 +214,37 @@ SELECT [ ALL | DISTINCT [ ON <replaceable class="PARAMETER">column</replaceable>
<para>
The GROUP BY clause allows a user to divide a table
conceptually into groups.
- (See <xref linkend="group-by-title" endterm="group-by-title">.)
+ (See <xref linkend="sql-groupby" endterm="sql-groupby-title">.)
</para>
<para>
The HAVING clause specifies a grouped table derived by the
elimination of groups from the result of the previously
specified clause.
- (See <xref linkend="having-title" endterm="having-title">.)
+ (See <xref linkend="sql-having" endterm="sql-having-title">.)
</para>
<para>
The ORDER BY clause allows a user to specify that he/she
wishes the rows sorted according to the ASCending or
DESCending mode operator.
- (See <xref linkend="order-by-title" endterm="order-by-title">.)
+ (See <xref linkend="sql-orderby-title" endterm="sql-orderby-title">.)
</para>
<para>
The UNION clause allows the result to be the collection of rows
returned by the queries involved.
- (See <xref linkend="union-title" endterm="union-title">.)
+ (See <xref linkend="sql-union" endterm="sql-union-title">.)
</para>
<para>
The INTERSECT give you the rows that are common to both queries.
- (See <xref linkend="intersect-title" endterm="intersect-title">.)
+ (See <xref linkend="sql-intersect" endterm="sql-intersect-title">.)
</para>
<para>
The EXCEPT give you the rows in the upper query not in the lower query.
- (See <xref linkend="except-title" endterm="except-title">.)
+ (See <xref linkend="sql-except" endterm="sql-except-title">.)
</para>
<para>
@@ -262,11 +262,11 @@ SELECT [ ALL | DISTINCT [ ON <replaceable class="PARAMETER">column</replaceable>
(See the <command>GRANT</command>/<command>REVOKE</command> statements).
</para>
- <refsect2 id="R2-SQL-WHERE-2">
+ <refsect2 id="SQL-WHERE">
<refsect2info>
<date>1998-09-24</date>
</refsect2info>
- <title id="where-title">
+ <title id="sql-where-title">
WHERE Clause
</title>
@@ -303,11 +303,11 @@ WHERE <replaceable class="PARAMETER">boolean_expr</replaceable>
</para>
</refsect2>
- <refsect2 id="R2-SQL-GROUPBY-2">
+ <refsect2 id="SQL-GROUPBY">
<refsect2info>
<date>1998-09-24</date>
</refsect2info>
- <title id="group-by-title">
+ <title id="sql-groupby-title">
GROUP BY Clause
</title>
<para>
@@ -328,11 +328,11 @@ GROUP BY <replaceable class="PARAMETER">column</replaceable> [, ...]
</para>
</refsect2>
- <refsect2 id="R2-SQL-HAVING-2">
+ <refsect2 id="SQL-HAVING">
<refsect2info>
<date>1998-09-24</date>
</refsect2info>
- <title id="having-title">
+ <title id="sql-having-title">
HAVING Clause
</title>
<para>
@@ -358,11 +358,11 @@ HAVING <replaceable class="PARAMETER">cond_expr</replaceable>
</para>
</refsect2>
- <refsect2 id="R2-SQL-ORDERBYCLAUSE-2">
+ <refsect2 id="SQL-ORDERBY">
<refsect2info>
<date>1998-09-24</date>
</refsect2info>
- <title id="order-by-title">
+ <title id="sql-orderby-title">
ORDER BY Clause
</title>
<para>
@@ -401,11 +401,11 @@ SELECT name FROM distributors ORDER BY code;
</para>
</refsect2>
- <refsect2 id="R2-SQL-UNION-2">
+ <refsect2 id="SQL-UNION">
<refsect2info>
<date>1998-09-24</date>
</refsect2info>
- <title id="union-title">
+ <title id="sql-union-title">
UNION Clause
</title>
<para>
@@ -441,11 +441,11 @@ SELECT name FROM distributors ORDER BY code;
</refsect2>
- <refsect2 id="R2-SQL-INTERSECT-2">
+ <refsect2 id="SQL-INTERSECT">
<refsect2info>
<date>1998-09-24</date>
</refsect2info>
- <title id="intersect-title">
+ <title id="sql-intersect-title">
INTERSECT Clause
</title>
<para>
@@ -473,11 +473,11 @@ SELECT name FROM distributors ORDER BY code;
</para>
</refsect2>
- <refsect2 id="R2-SQL-EXCEPT-2">
+ <refsect2 id="SQL-EXCEPT">
<refsect2info>
<date>1998-09-24</date>
</refsect2info>
- <title id="except-title">
+ <title id="sql-except-title">
EXCEPT Clause
</title>
<para>
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-04 20:30:31 +0000