Skip site navigation (1) Skip section navigation (2)

Re: Porting from MySQL to postgreSQL. Question RE: Sequence Dependencies

From: Charlie Clark <charlie(at)begeistert(dot)org>
To: Robert Starr <rob(at)surrenderdorothy(dot)com(dot)au>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Porting from MySQL to postgreSQL. Question RE: Sequence Dependencies
Date: 2007-09-13 06:17:45
Message-ID: 37BA912D-3D8C-49BD-AC88-5DB4F8A5B5CA@begeistert.org (view raw or flat)
Thread:
Lists: pgadmin-support
Am 13.09.2007 um 05:24 schrieb Robert Starr:

> Hi all,  this is my first post.  I have a quick question, and if I  
> have it all wrong I apologise in advance, I'm still trying to get  
> used to a 'real' SQL after moving away from MySQL.

Welcome aboard!

This list is actually for pgAdmin which is just the GUI admin tool  
for the PostgreSQL RDBMS. You might want to sign-up to one of the  
postgresql lists such as the general list for questions.

 From your posts it looks like you understand the principles of  
relational databases which PostgreSQL actually implements rather than  
just paying lip service. And if you think relationally you'll find  
PostgreSQL a lot more fun to work with. For migrating from MySQL it's  
probably worth noting that there is an option for exporting MySQL in  
nearly PostgreSQL compatible syntax. I don't know if there is a  
migration guide but there probably should be.

Good luck with your migration!

Charlie
--
Charlie Clark
Helmholtzstr. 20
Düsseldorf
D- 40215
Tel: +49-211-938-5360
GSM: +49-178-782-6226




In response to

pgadmin-support by date

Next:From: Harald Armin MassaDate: 2007-09-13 08:00:49
Subject: pgadmin 8.3 beta 5: ERROR: permission denied for tablespace pg_default
Previous:From: Laurent YaishDate: 2007-09-13 06:11:12
Subject: Re: ERROR: duplicate key violates unique constraint "client_alerts_PK"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group