File: manage412.html

package info (click to toggle)
mpsql 2.1-2
links: PTS
area: non-free
in suites: potato
size: 3,528 kB
ctags: 4,886
sloc: ansic: 35,184; makefile: 3,761; sh: 44
file content (286 lines) | stat: -rw-r--r-- 5,196 bytes
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML
><HEAD
><TITLE
>Accessing a Database</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet version 1.19"><LINK
REL="HOME"
TITLE="PostgreSQL User's Guide"
HREF="user.html"><LINK
REL="UP"
TITLE="Managing a Database"
HREF="manage.html"><LINK
REL="PREVIOUS"
TITLE="Alternate Database Locations"
HREF="manage387.html"><LINK
REL="NEXT"
TITLE="Destroying a Database"
HREF="manage453.html"></HEAD
><BODY
BGCOLOR="#FFFFFF"
TEXT="#000000"
><DIV
CLASS="NAVHEADER"
><TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="3"
ALIGN="center"
>PostgreSQL User's Guide</TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="bottom"
><A
HREF="manage387.html"
>Prev</A
></TD
><TD
WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
>Chapter 3. Managing a Database</TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
><A
HREF="manage453.html"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><H1
CLASS="SECT1"
><A
NAME="AEN412"
>Accessing a Database</A
></H1
><P
>     Once you have constructed a database, you can access it
     by:

<P
></P
></P><UL
COMPACT="COMPACT"
><LI
STYLE="list-style-type: disc"
><P
>running the <SPAN
CLASS="PRODUCTNAME"
>Postgres</SPAN
>  terminal  monitor  programs  (e.g.
        <SPAN
CLASS="APPLICATION"
>psql</SPAN
>) which allows you to interactively
        enter, edit, and execute <SPAN
CLASS="ACRONYM"
>SQL</SPAN
> commands.</P
></LI
><LI
STYLE="list-style-type: disc"
><P
>      writing a  C  program  using  the  LIBPQ  subroutine
        library.   This  allows  you  to submit <SPAN
CLASS="ACRONYM"
>SQL</SPAN
> commands
        from C and get answers and status messages  back  to
        your  program.   This interface is discussed further
        in section ??.</P
></LI
></UL
><P>

You might want to start up <SPAN
CLASS="APPLICATION"
>psql</SPAN
>, to try out the examples in this manual.
 It can be activated for the <SPAN
CLASS="DATABASE"
>mydb</SPAN
>
     database by typing the command:
<PRE
CLASS="PROGRAMLISTING"
>% psql mydb</PRE
>

     You will be greeted with the following message:
<PRE
CLASS="PROGRAMLISTING"
>Welcome to the POSTGRESQL interactive sql monitor:
  Please read the file COPYRIGHT for copyright terms of POSTGRESQL

   type \? for help on slash commands
   type \q to quit
   type \g or terminate with semicolon to execute query
 You are currently connected to the database: template1

mydb=&#62;</PRE
></P
><P
>This prompt indicates that the terminal monitor is listening
  to you and that you can type <SPAN
CLASS="ACRONYM"
>SQL</SPAN
> queries into a
     workspace maintained by the terminal monitor.
     The <SPAN
CLASS="APPLICATION"
>psql</SPAN
> program responds to escape  codes  that  begin
     with  the  backslash  character, &#8220;\&#8221;  For example, you
     can get help on the syntax of various
 <SPAN
CLASS="PRODUCTNAME"
>Postgres</SPAN
> <SPAN
CLASS="ACRONYM"
>SQL</SPAN
> commands by typing:
<PRE
CLASS="PROGRAMLISTING"
>mydb=&#62; \h</PRE
>

     Once  you  have finished entering your queries into the
     workspace, you can pass the contents of  the  workspace
     to the <SPAN
CLASS="PRODUCTNAME"
>Postgres</SPAN
> server by typing:
<PRE
CLASS="PROGRAMLISTING"
>mydb=&#62; \g</PRE
>

     This  tells  the  server  to process the query.  If you
     terminate your query with a semicolon, the  &#8220;\g&#8221; is  not
     necessary.   <SPAN
CLASS="APPLICATION"
>psql</SPAN
> will automatically process semicolon terminated queries.
     To read queries from a file,  say  myFile,  instead  of
     entering them interactively, type:
<PRE
CLASS="PROGRAMLISTING"
>mydb=&#62; \i fileName</PRE
>

     To get out of <SPAN
CLASS="APPLICATION"
>psql</SPAN
> and return to UNIX, type
<PRE
CLASS="PROGRAMLISTING"
>mydb=&#62; \q</PRE
>

     and  <SPAN
CLASS="APPLICATION"
>psql</SPAN
>  will  quit  and  return  you to your command
     shell. (For more escape codes, type <B
CLASS="COMMAND"
>\h</B
> at  the  monitor
     prompt.)
     White  space  (i.e.,  spaces, tabs and newlines) may be
     used freely in <SPAN
CLASS="ACRONYM"
>SQL</SPAN
> queries.  Single-line comments  are  denoted  by
     &#8220;--&#8221;.   Everything  after the dashes up to the end of the
     line is ignored. Multiple-line comments, and comments within a line,
     are denoted by &#8220;/* ... */&#8221;</P
><H2
CLASS="SECT2"
><A
NAME="AEN447"
>Database Privileges</A
></H2
><P
></P
><H2
CLASS="SECT2"
><A
NAME="AEN450"
>Table Privileges</A
></H2
><P
>TBD</P
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="manage387.html"
>Prev</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="user.html"
>Home</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="manage453.html"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>Alternate Database Locations</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="manage.html"
>Up</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>Destroying a Database</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>