MANSOURCES=$(wildcard ref/*.sgml)

APPLICATIONS= createdb.sgml createuser.sgml\

createlang.sgml\

dropdb.sgml dropuser.sgml\

droplang.sgml\

APPLICATIONS= createdb.sgml createlang.sgml createuser.sgml\

dropdb.sgml droplang.sgml dropuser.sgml\

ecpg-ref.sgml\

initdb.sgml initlocation.sgml\

ipcclean.sgml\

pg_dump.sgml\

pg_dumpall.sgml\

pg_passwd.sgml\

pg_upgrade.sgml\

pgaccess-ref.sgml\

pgadmin-ref.sgml\

pgctl-ref.sgml\

pgtclsh.sgml\

pgtksh.sgml\

postgres-ref.sgml\

COMMANDS= abort.sgml alter_group.sgml alter_table.sgml alter_user.sgml\

begin.sgml\

close.sgml cluster.sgml commit.sgml copy.sgml\

create_aggregate.sgml create_database.sgml create_function.sgml create_group.sgml\

close.sgml cluster.sgml comment.sgml commit.sgml copy.sgml\

create_aggregate.sgml create_constraint.sgml create_database.sgml\

create_function.sgml create_group.sgml\

create_index.sgml\

create_language.sgml create_operator.sgml create_rule.sgml create_sequence.sgml\

create_table.sgml create_table_as.sgml create_trigger.sgml create_type.sgml\

drop_index.sgml\

drop_language.sgml drop_operator.sgml drop_rule.sgml drop_sequence.sgml\

drop_table.sgml drop_trigger.sgml drop_type.sgml drop_user.sgml drop_view.sgml\

explain.sgml fetch.sgml grant.sgml\

end.sgmlexplain.sgml fetch.sgml grant.sgml\

insert.sgml listen.sgml load.sgml lock.sgml move.sgml\

notify.sgml\

reset.sgml revoke.sgml rollback.sgml\

reindex.sgmlreset.sgml revoke.sgml rollback.sgml\

select.sgml select_into.sgml set.sgml show.sgml\

unlisten.sgml update.sgml vacuum.sgml

truncate.sgmlunlisten.sgml update.sgml vacuum.sgml

FUNCTIONS= current_date.sgml current_time.sgml current_timestamp.sgml current_user.sgml

<!--

$Header: /cvsroot/pgsql/doc/src/sgml/Attic/admin.sgml,v 1.21 2000/03/31 03:27:40 thomas Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/Attic/admin.sgml,v 1.22 2000/05/02 20:01:51 thomas Exp $

Postgres Administrator's Guide.

Derived from postgres.sgml.

<!entity biblio SYSTEM "biblio.sgml">

]>

<Book Id="admin">

<book id="admin">

<!-- Title information -->

<Title>PostgreSQL Administrator's Guide</Title>

<BookInfo>

<ReleaseInfo>Coveringv6.5 for general release</ReleaseInfo>

<BookBiblio>

<AuthorGroup>

<CorpAuthor>The PostgreSQL Development Team</CorpAuthor>

</AuthorGroup>

<title>PostgreSQL Administrator's Guide</title>

<bookinfo>

<releaseinfo>Coveringv7.0 for general release</releaseinfo>

<bookbiblio>

<authorgroup>

<corpauthor>The PostgreSQL Development Team</corpauthor>

</authorgroup>

<!-- editor in authorgroup is not supported

<AuthorGroup>

-->

<Editor>

<FirstName>Thomas</FirstName>

<SurName>Lockhart</SurName>

<Affiliation>

<OrgName>Caltech/JPL</OrgName>

</Affiliation>

</Editor>

<editor>

<firstname>Thomas</firstname>

<surname>Lockhart</surname>

<affiliation>

<orgname>Caltech/JPL</orgname>

</affiliation>

</editor>

<!--

</AuthorGroup>

-->

<AuthorInitials>TGL</AuthorInitials>

-->

<Date>(last updated1999-06-01)</Date>

</BookBiblio>

<date>(last updated2000-05-01)</date>

</bookbiblio>

<LegalNotice>

<Para>

<ProductName>PostgreSQL</ProductName> is Copyright &copy; 1996-9

bythe Postgres Global Development Group.

</Para>

</LegalNotice>

<legalnotice>

<para>

<productname>PostgreSQL</productname> is Copyright &copy; 1996-2000

byPostgreSQL Inc.

</para>

</legalnotice>

</BookInfo>

</bookinfo>

<!--

<TOC> </TOC>

</Dedication>

-->

<Preface id="preface">

<Title>Summary</Title>

<preface id="preface">

<title>Summary</title>

<Para>

<ProductName>Postgres</ProductName>,

<para>

<productname>Postgres</productname>,

developed originally in the UC Berkeley Computer Science Department,

pioneered many of the object-relational concepts

now becoming available in some commercial databases.

It provides SQL92/SQL3 language support,

transaction integrity, and type extensibility.

<ProductName>PostgreSQL</ProductName> is an open-source descendant

<productname>PostgreSQL</productname> is an open-source descendant

of this original Berkeley code.

</Para>

</Preface>

</para>

</preface>

&intro-ag;

</index>

-->

</Book>

</book>

<!-- Keep this comment at the end of the file

Local variables:

<!--

$Header: /cvsroot/pgsql/doc/src/sgml/advanced.sgml,v 1.11 2000/04/11 05:39:06 thomas Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/advanced.sgml,v 1.12 2000/05/02 20:01:51 thomas Exp $

-->

<chapter id="advanced">

+----------+----------+

</programlisting>

Here the<quote>*</quote> after cities indicates that the query should

Here the"*" after cities indicates that the query should

be run over cities and all classes below cities in the

inheritance hierarchy. Many of the commands that we

have already discussed (<command>SELECT</command>,

<command>UPDATE</command> and <command>DELETE</command>)

support this<quote>*</quote> notation,as doothers, like

support thisinheritance notation using "*"as doother commands like

<command>ALTER</command>.

</para>

</sect1>

<!--

$Header: /cvsroot/pgsql/doc/src/sgml/biblio.sgml,v 1.12 2000/03/31 03:27:40 thomas Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/biblio.sgml,v 1.13 2000/05/02 20:01:51 thomas Exp $

-->

<bibliography id="biblio">

<productname>Postgres</productname> development team

are available at

<ulink url="http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/papers/">

http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/papers/</ulink>

the University of California, Berkeley, Computer Science

Department web site</ulink>

</para>

<bibliodiv>

<surname>Lockhart</surname>

</editor>

<pubdate>1998-10-01</pubdate>

<pubdate>2000-05-01</pubdate>

<publisher>

<publishername>The PostgreSQL Global Development Group</publishername>

</publisher>

<surname>Lockhart</surname>

</editor>

<pubdate>1998-10-01</pubdate>

<pubdate>2000-05-01</pubdate>

<publisher>

<publishername>The PostgreSQL Global Development Group</publishername>

</publisher>

<surname>Lockhart</surname>

</editor>

<pubdate>1998-10-01</pubdate>

<pubdate>2000-05-01</pubdate>

<publisher>

<publishername>The PostgreSQL Global Development Group</publishername>

</publisher>

<surname>Lockhart</surname>

</editor>

<pubdate>1998-10-01</pubdate>

<pubdate>2000-05-01</pubdate>

<publisher>

<publishername>The PostgreSQL Global Development Group</publishername>

</publisher>

<surname>Lockhart</surname>

</editor>

<pubdate>1998-10-01</pubdate>

<pubdate>2000-05-01</pubdate>

<publisher>

<publishername>The PostgreSQL Global Development Group</publishername>

</publisher>

</ulink>

</title>

<titleabbrev id="SESHADRI95">

Seshardri, 1995

</titleabbrev>

<authorgroup>

<author>

<!--

$Header: /cvsroot/pgsql/doc/src/sgml/bki.sgml,v 1.2 1998/12/29 02:24:13 thomas Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/bki.sgml,v 1.3 2000/05/02 20:01:51 thomas Exp $

Transcribed from the original bki.man.5 documentation

- Thomas Lockhart 1998-08-03

and the <acronym>SQL</acronym> command <command>CREATE DATABASE</command>.

</para>

<sect1>

<title><acronym>BKI</acronym> File Format</title>

<sect1>

<title><acronym>BKI</acronym> File Format</title>

<para>

The <productname>Postgres</productname> backend interprets <acronym>BKI</acronym> files as described below. This

description will be easier to understand if the <filename>global1.bki.source</filename> file is

at hand as an example. (As explained above, this .source file isn't quite

a <acronym>BKI</acronym> file, but you'll be able to guess what the resulting <acronym>BKI</acronym> file would be

anyway).

</para>

<para>

The <productname>Postgres</productname> backend interprets

<acronym>BKI</acronym> files as described below. This

description will be easier to understand if the

<filename>global1.bki.source</filename> file is

at hand as an example. (As explained above, this .source file isn't quite

a <acronym>BKI</acronym> file, but you'll be able to guess what

the resulting <acronym>BKI</acronym> file would be

anyway).

</para>

<para>

Commands are composed of a command name followed by space separated

arguments. Arguments to a command which begin with a<quote>$</quote> are

treated specially. If<quote>$$</quote> are the first two characters, then

the first<quote>$</quote> is ignored and the argument is then processed

normally. If the<quote>$</quote> is followed by space, then it is treated

arguments. Arguments to a command which begin with a"$" are

treated specially. If"$$" are the first two characters, then

the first"$" is ignored and the argument is then processed

normally. If the"$" is followed by space, then it is treated

as a NULL

value. Otherwise, the characters following the<quote>$</quote> are

value. Otherwise, the characters following the"$" are

interpreted as the name of a macro causing the argument to be replaced

with the macro's value. It is an error for this macro to be

undefined.

<replaceable class="parameter">oid_value</replaceable>

for its OID. If

<replaceable class="parameter">oid_value</replaceable>

is not<quote>0</quote>, then this value will be used as the instance's

is notzero (0), then this value will be used as the instance's

object identifier. Otherwise, it is an error.

</para>

</listitem>

<title>Example</title>

<para>

The following set of commands will create the <quote>pg_opclass</quote>

The following set of commands will create the <literal>pg_opclass</literal>

class containing the

<parameter>int_ops</parameter>

collection as an object with an OID of

</para>

</sect1>

</chapter>

<!-- 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:

-->