Thread: 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 : paumarc.munoz@bioinf.uab.cat

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).

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

On Nov 15, 2007 10:44 AM, Pau Marc Munoz Torres <paumarc@gmail.com> 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 <command> in the shell will give you help for the command and
\d <table> well 'describe' the table

good luck!!
merlin

Thanks every body, today i've created my first table with postgresql, what a mass with \d <table> and sequancial vs auto_increment data type in create... anyway, i will become an expert soon

;-)

thanks again

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 : paumarc.munoz@bioinf.uab.cat