Re: moving from mysql to postgree

On Nov 15, 2007 10:44 AM, Pau Marc Munoz Torres <paumarc(at)gmail(dot)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