Re: [GENERAL] moving from mysql to postgree
On Nov 15, 2007 10:44 AM, Pau Marc Munoz Torres <[EMAIL PROTECTED]> wrote: > I'm moving from mysql to postgresql just now i I'm a bit lost, could anyone > tell me some place with a comparative between postdresql and mysql commands, > i think than mostly is the same think but, any way, do anything change ? IMO, he biggest differences between mysql and postgresql for beginners are: * database authentication (pg_hba.conf and user set up) * create/alter table syntax * dealing with timestamps/default expressions * update and delete statements that deal with more than one table postgresql has a _much_ better command shell than mysql. It has tab-completions for commands as well as database objects and has syntax help for all commands. This is an absolutely essential help to the beginner. (some of the gui tools, like pgadmin, have this as well but i use the shell almost exclusively). \h in the shell will give you help for the command and \d well 'describe' the table good luck!! merlin ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] moving from mysql to postgree
Thanks every body, today i've created my first table with postgresql, what a mass with \d and sequancial vs auto_increment data type in create... anyway, i will become an expert soon ;-) thanks again pau 2007/11/16, Merlin Moncure <[EMAIL PROTECTED]>: > > On Nov 15, 2007 10:44 AM, Pau Marc Munoz Torres <[EMAIL PROTECTED]> wrote: > > I'm moving from mysql to postgresql just now i I'm a bit lost, could > anyone > > tell me some place with a comparative between postdresql and mysql > commands, > > i think than mostly is the same think but, any way, do anything change ? > > IMO, he biggest differences between mysql and postgresql for beginners > are: > * database authentication (pg_hba.conf and user set up) > * create/alter table syntax > * dealing with timestamps/default expressions > * update and delete statements that deal with more than one table > > postgresql has a _much_ better command shell than mysql. It has > tab-completions for commands as well as database objects and has > syntax help for all commands. This is an absolutely essential help to > the beginner. (some of the gui tools, like pgadmin, have this as well > but i use the shell almost exclusively). > > \h in the shell will give you help for the command and > \d well 'describe' the table > > good luck!! > merlin > -- Pau Marc Muñoz Torres Laboratori de Biologia Computacional Institut de Biotecnologia i Biomedicina Vicent Villar Universitat Autonoma de Barcelona E-08193 Bellaterra (Barcelona) telèfon: 93 5812807 Email : [EMAIL PROTECTED]
Re: [GENERAL] moving from mysql to postgree
On Thu, Nov 15, 2007 at 04:44:33PM +0100, Pau Marc Munoz Torres wrote: > I'm moving from mysql to postgresql just now i I'm a bit lost, could anyone > tell me some place with a comparative between postdresql and mysql commands, > i think than mostly is the same think but, any way, do anything change ? You can probably get a reasonable sense of the differences by looking at section VI of the manual -- it's basically the "man page" version of every SQL statement. That said, I _very strongly_ encourage you to read the whole manual, at least once. It's admittedly a bit of a slog, but there are a number of deep conceptual differences between PostgreSQL and MySQL that will possibly bite you unless you are prepared for them. Better to be prepared than to be up at 3 AM :) If you are not familiar with MySQL's "strict mode", then the above is even more important. If you _are_ familiar with strict mode, then think of PostgreSQL as strict mode done properly, and which you can't shut off. There are also some MySQL-to-PostgreSQL comparison sites around that you'll want to read. A -- Andrew Sullivan Old sigs will return after re-constitution of blue smoke ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] moving from mysql to postgree
Pau Marc Munoz Torres wrote: Hi I'm moving from mysql to postgresql just now i I'm a bit lost, could anyone tell me some place with a comparative between postdresql and mysql commands, i think than mostly is the same think but, any way, do anything change ? pau -- Hi, You should check out Lightning Admin. We have a version for both that have the same look and feel and could make the transition easier. You can also ask questions at our forums: http://www.amsoftwaredesign.com/smf regarding moving from MySQL to PostgreSQL. Tony Caduto http://www.amsoftwaredesign.com Home of Lightning Admin for PostgreSQL and MySQL Both versions for 24.99 (limited time only). ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[GENERAL] moving from mysql to postgree
Hi I'm moving from mysql to postgresql just now i I'm a bit lost, could anyone tell me some place with a comparative between postdresql and mysql commands, i think than mostly is the same think but, any way, do anything change ? pau -- Pau Marc Muñoz Torres Laboratori de Biologia Computacional Institut de Biotecnologia i Biomedicina Vicent Villar Universitat Autonoma de Barcelona E-08193 Bellaterra (Barcelona) telèfon: 93 5812807 Email : [EMAIL PROTECTED]
