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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgadmin-support by date

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