Geek asks and answers

Access Postgresql Equivalent Auto Dial

I am trying to create a database for my company, and my programmer does not know how to get a number that is populated, as in Access 2003. In Access, you can have a car number with a field, and it will be inserted for you, How do you do it in Postgresql ? My programmer needs help and he cannot find the book. Many thanks!

+3
source share
1 answer

Postgresql Documentation: 8.1.4. Series Types

CREATE TABLE tablename (
    colname SERIAL
);

Types of data serialand bigserialare not true types, but merely a convenience to refer to create a unique identifier columns (similar to an AUTO_INCREMENT property, supported by some other databases).

+8
source

More articles:


All Articles