Search Postgresql Archives

Re: moving from mysql to postgree

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

2007/11/16, Merlin Moncure <mmoncure@xxxxxxxxx>:
On Nov 15, 2007 10:44 AM, Pau Marc Munoz Torres <paumarc@xxxxxxxxx> 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



--
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@xxxxxxxxxxxxxx

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux