\name{createSequence}
\alias{createSequence}
\title{Creating a PgSQL SEQUENCE}
\description{
  \code{createSequence} creates a PostgreSQL SEQUENCE. SEQUENCEs allow the creation of autoincrementing sequences.
}
\usage{
createSequence(con, name=NULL, increment=1, start=100)
}
\arguments{
  \item{con}{A connection object (create it with the dbConnect.PgSQL.conn function from the package RdbiPgSQL)}
  \item{name}{The name for the sequence}
  \item{increment}{the value to increment the sequence by each call, by default 1.}
  \item{start}{the starting value of the sequence, by default 100.}
}
\details{
creates a PostgreSQL SEQUENCE table. Such a sequence table can be used to get unique numbers and are therefore ideal for Primary keys (by creating a table with the default call createDBTable also a sequence will be created, to get unique Primary keys for the rows). To get the next value from the sequece only call nextval('<sequence name>'). For more details look in the PostgreSQL reference manual.
}
\references{}
\author{Johannes Rainer}

\seealso{
    \code{\link{createDBTable}}
}

\keyword{data}