Re: New To PostgreSQL

Tom Ince wrote:
>
> 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. PostgreSQL supports foreign keys and a whole lot of other stuff,
kindly check out the documents at http://techdocs.postgresql.org.

=)

--
     /) John Clark Naldoza y Lopez                           (\
    / )    Software Design Engineer III                      ( \
  _( (_    _  Web-Application Development                    _) )_
 (((\ \>  /_>    Cable Modem Network Management System <_\  </ /)))
 (\\\\ \_/ /         NEC Telecom Software Phils., Inc.  \ \_/ ////)
  \       /                                              \       /
   \    _/  phone: (+63 32) 233-9142 loc. 3113            \_    /
   /   /  cellphone: (+63 919) 399-4742                     \   \
  /   / email: njclark@ntsp.nec.co.jp                        \   \


"Intelligence is the ability to avoid doing work, yet getting the work
done"
--Linus Torvalds