Re: [GENERAL] Some MySQL features

vincent leycuras wrote:

> I'd like to know if pgsql supports the two excellent features that exist in
> MySQL:
> - the possibility to load the database with ASCII formatted file containing
> the data we want to put;

Sure. This is the copy routine. But it is also easy to load data with
programs (perl DBI/DBD)

> - the index auto incrementation the prevents from having to specify the
> value of the primary key each time one adds a row.

Sure. You may define a sequence by doing this:

create sequence xxx_id_seq START 1;
create table xxy
(
xxx_Id INTEGER NOT NULL
DEFAULT NEXTVAL('xxx_id_seq'),
...
);

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Herbert Liechti E-Mail: Herbert(dot)Liechti(at)thinx(dot)ch
ThinX networked business services Stahlrain 10, CH-5200 Brugg
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~