Re: New To PostgreSQL

"Tom Ince" <tince@acsinc-nj.com> writes:

> I am attempting to convert an database currently running on Informix to
> a free database on Linux (RedHat 6.1).  I have a question.....
>
> I learned that MySQL, does not maintain foreign keys, which affects me
> because I need to use things like CHECK in the CREATE TABLE statements.
> So thats why I am not trying PostgreSQL.  Does PostgreSQL support
> foreign keys?  Are there any other quirks I might run into as far as
> SQL syntax goes?

Yes, recent versions of PostgreSQL support foreign keys and general
CHECK constraints as well.  You will probably run into some SQL
differences between Informix and Postgres but I don't think they are
major.

The PG documentation is online at www.postgresql.org, feel free to
check it out if you haven't already.

-Doug
--
In a world of steel-eyed death, and men who are fighting to be warm,
Come in, she said, I'll give you shelter from the storm.    -Dylan