Received: from fslc.ser.usu.edu (fslc.ser.usu.edu [129.123.28.122]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f56H3IE29788 for ; Wed, 6 Jun 2001 13:03:18 -0400 (EDT) (envelope-from rmello@fslc.usu.edu) Received: (from rmello@localhost) by fslc.ser.usu.edu (8.12.0.Beta5/8.12.0.Beta5/Debian 8.12.0-1) id f56H3E6p005360; Wed, 6 Jun 2001 11:03:14 -0600 Date: Wed, 6 Jun 2001 11:03:14 -0600 From: Roberto Mello To: Mario Bittencourt Cc: pgsql-sql@postgresql.org Subject: Re: Tutorial : using foreign keys, retrictions etc Message-ID: <20010606110314.B5229@cc.usu.edu> References: <9fbq01$19jl$1@news.tht.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <9fbq01$19jl$1@news.tht.net> User-Agent: Mutt/1.3.18i X-Archive-Number: 200106/69 X-Sequence-Number: 3287 On Sat, Jun 02, 2001 at 06:49:55PM -0400, Mario Bittencourt wrote: > Hi, > > I've decided to switch from mysql to postgresql as my database server. Good for you :) > procedures, views) and I'd like to know if there is some tutorial/snippet > of code regarding such features specially the use of foreign keys and > referetial integrity. You might want to look at http://techdocs.postgresql.org. IIRC, a script to "port" MySQL code to PostgreSQL has been included in the contrib section of 7.1.x. For examples of functions, head to http://www.brasileiro.net/postgres -Roberto -- +----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Developer Bad command or file name. Go sit in corner.