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(at)ntsp(dot)nec(dot)co(dot)jp \ \

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