Re: create table with table constraints

On Tue, Dec 13, 2005 at 07:46:10PM -0800, Jim Beckstrom wrote:
> A sample, please, of the syntax for creating a table with unique
> table constraint.  I thought I followed the online manual syntax,
> but only got a parser error pointing to the opening paren following
> "CREATE TABLE".

What part of the manual were you looking at?  There are several
examples in the "Constraints" section of the "Data Definition"
chapter:

http://www.postgresql.org/docs/8.1/interactive/ddl-constraints.html

If that doesn't help then please show the exact command you ran and
the exact error message; that way we can point out what's wrong and
why it's wrong.  It might also be useful to know what version of
PostgreSQL you're running.

--
Michael Fuhr