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.Liechti@thinx.ch
ThinX networked business services Stahlrain 10, CH-5200 Brugg
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~