resubmitting FAQ updates based on html version.

Robert Treat

On Friday 19 March 2004 10:56, Bruce Momjian wrote:
> Can I get HTML diffs against contrib/src/FAQ.html?
>
> ---------------------------------------------------------------------------
>
> Robert Treat wrote:
> > Updated a few FAQ entries.
> >
> > Robert Treat
> > --
> > Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
>
> [ Attachment, skipping... ]
>
> > ---------------------------(end of broadcast)---------------------------
> > TIP 7: don't forget to increase your free space map settings

-- 
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
Index: FAQ.html
===================================================================
RCS file: /projects/cvsroot/pgsql-server/doc/src/FAQ/FAQ.html,v
retrieving revision 1.213
diff -c -r1.213 FAQ.html
*** FAQ.html	12 Mar 2004 13:51:57 -0000	1.213
--- FAQ.html	28 Mar 2004 06:20:46 -0000
***************
*** 156,166 ****
  
      <H4><A name="1.1">1.1</A>) What is PostgreSQL? How is it pronounced?</H4>
  
!     <P>PostgreSQL is pronounced <I>Post-Gres-Q-L</I>.  The name "Postgres" is
!     also used in conversation.</P>
  
      <P>PostgreSQL is an enhancement of the POSTGRES database management
!     system, a next-generation <SMALL>DBMS</SMALL> research prototype.
      While PostgreSQL retains the powerful data model and rich data
      types of POSTGRES, it replaces the PostQuel query language with an
      extended subset of <SMALL>SQL</SMALL>. PostgreSQL is free and the
--- 156,169 ----
  
      <H4><A name="1.1">1.1</A>) What is PostgreSQL? How is it pronounced?</H4>
  
!     <P>PostgreSQL is pronounced <I>Post-Gres-Q-L</I>.  An audio file is 
!        available at http://www.postgresql.org/postgresql.mp3 for those 
!        would like to hear the pronunciation. 
!     </P>
  
      <P>PostgreSQL is an enhancement of the POSTGRES database management
!     system (and is still sometimes reffered to as simply "Postgres"), 
!     a next-generation <SMALL>DBMS</SMALL> research prototype.
      While PostgreSQL retains the powerful data model and rich data
      types of POSTGRES, it replaces the PostQuel query language with an
      extended subset of <SMALL>SQL</SMALL>. PostgreSQL is free and the
***************
*** 173,179 ****
      section <a href="#1.6">1.6</a> on how to join). This team is now
      responsible for all development of PostgreSQL.  It is a community
      project and is not controlled by any company.  To get involved, see
!     the developer's FAQ,<A href=
      "http://www.PostgreSQL.org/docs/faqs/FAQ_DEV.html";>http://www.PostgreSQL.org/docs/faqs/FAQ_DEV.html</A>
      </P>
  
--- 176,182 ----
      section <a href="#1.6">1.6</a> on how to join). This team is now
      responsible for all development of PostgreSQL.  It is a community
      project and is not controlled by any company.  To get involved, see
!     the developer's FAQ at <A href=
      "http://www.PostgreSQL.org/docs/faqs/FAQ_DEV.html";>http://www.PostgreSQL.org/docs/faqs/FAQ_DEV.html</A>
      </P>
  
***************
*** 197,203 ****
  
      <P>PostgreSQL Data Base Management System</P>
  
!     <P>Portions copyright (c) 1996-2002, PostgreSQL Global Development
      Group Portions Copyright (c) 1994-6 Regents of the University of
      California</P>
  
--- 200,206 ----
  
      <P>PostgreSQL Data Base Management System</P>
  
!     <P>Portions copyright (c) 1996-2004, PostgreSQL Global Development
      Group Portions Copyright (c) 1994-6 Regents of the University of
      California</P>
  
***************
*** 227,233 ****
      <H4><A name="1.3">1.3</A>) What Unix platforms does PostgreSQL run
      on?</H4>
  
!     <P>In general, a modern Unix-compatible platform should be able to
      run PostgreSQL. The platforms that had received explicit testing at
      the time of release are listed in the installation
      instructions.</P>
--- 230,236 ----
      <H4><A name="1.3">1.3</A>) What Unix platforms does PostgreSQL run
      on?</H4>
  
!     <P>In general, any modern Unix-compatible platform should be able to
      run PostgreSQL. The platforms that had received explicit testing at
      the time of release are listed in the installation
      instructions.</P>
***************
*** 563,569 ****
      href="http://sources.redhat.com/rhdb/";>http://sources.redhat.com/rhdb/
      </a>) and Rekall (<a href="http://www.thekompany.com/products/rekall/";>
      http://www.thekompany.com/products/rekall/</a>, proprietary). There is 
!     also PHPPgAdmin (<a href="http://phppgadmin.sourceforge.net/";>
      http://phppgadmin.sourceforge.net/ </a>), a web-based interface to 
      PostgreSQL.</P>
  
--- 566,572 ----
      href="http://sources.redhat.com/rhdb/";>http://sources.redhat.com/rhdb/
      </a>) and Rekall (<a href="http://www.thekompany.com/products/rekall/";>
      http://www.thekompany.com/products/rekall/</a>, proprietary). There is 
!     also PhpPgAdmin (<a href="http://phppgadmin.sourceforge.net/";>
      http://phppgadmin.sourceforge.net/ </a>), a web-based interface to 
      PostgreSQL.</P>
  
***************
*** 651,657 ****
  
      <P>By default, PostgreSQL only allows connections from the local
      machine using Unix domain sockets. Other machines will not be able
!     to connect unless you add the <I>-i</I> flag to <I>postmaster</I>,
      <B>and</B> enable host-based authentication by modifying the file
      <I>$PGDATA/pg_hba.conf</I> accordingly. This will allow TCP/IP
      connections.</P>
--- 654,660 ----
  
      <P>By default, PostgreSQL only allows connections from the local
      machine using Unix domain sockets. Other machines will not be able
!     to connect unless you turn on tcpip_sockets in the postgresql.conf  
      <B>and</B> enable host-based authentication by modifying the file
      <I>$PGDATA/pg_hba.conf</I> accordingly. This will allow TCP/IP
      connections.</P>
***************
*** 660,666 ****
      better performance?</H4>
  
      <P>Certainly, indexes can speed up queries. The
!     <SMALL>EXPLAIN</SMALL> command allows you to see how PostgreSQL is
      interpreting your query, and which indexes are being used.</P>
  
      <P>If you are doing many <SMALL>INSERTs</SMALL>, consider doing
--- 663,669 ----
      better performance?</H4>
  
      <P>Certainly, indexes can speed up queries. The
!     <SMALL>EXPLAIN ANALYZE</SMALL> command allows you to see how PostgreSQL is
      interpreting your query, and which indexes are being used.</P>
  
      <P>If you are doing many <SMALL>INSERTs</SMALL>, consider doing
***************
*** 837,848 ****
      <H4><A name="4.3">4.3</A>) How do I get a list of tables or other
      things I can see in <I>psql</I>?</H4>
  
!     <P>You can read the source code for <I>psql</I> in file
!     <I>pgsql/src/bin/psql/describe.c</I>. It contains
!     <SMALL>SQL</SMALL> commands that generate the output for psql's
!     backslash commands. You can also start <I>psql</I> with the
!     <I>-E</I> option so it will print out the queries it uses to
!     execute the commands you give.</P>
  
      <H4><A name="4.4">4.4</A>) How do you remove a column from a
      table, or change its data type?</H4>
--- 840,854 ----
      <H4><A name="4.3">4.3</A>) How do I get a list of tables or other
      things I can see in <I>psql</I>?</H4>
  
!     <P>Use the \dt command to see tables in <I>psql</I>. For a complete list of
!     commands inside psql you can use \?. Alternatively you can read the source 
!     code for <I>psql</I> in file <I>pgsql/src/bin/psql/describe.c</I>, it 
!     contains <SMALL>SQL</SMALL> commands that generate the output for 
!     <I>psql</I>'s backslash commands. You can also start <I>psql</I> with the
!     <I>-E</I> option so it will print out the queries it uses to execute the 
!     commands you give. PostgreSQL also provides an <SMALL>SQLi</SMALL> compliant
!     INFORMATION SCHEMA interface you can query to get information about the
!     database.</P>
  
      <H4><A name="4.4">4.4</A>) How do you remove a column from a
      table, or change its data type?</H4>
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org

Reply via email to