search

ondras / wwwsqldesigner

WWW SQL Designer, your online SQL diagramming tool
https://sql.toad.cz/?keyword=online_library
BSD 3-Clause "New" or "Revised" License
2.86k stars 722 forks source link

Primary key type in Postgres is always Serial #244

Open MartinEden opened 7 years ago

MartinEden commented 7 years ago

If I set my primary key type to VARCHAR, it still gets generated as SERIAL.

MartinEden commented 7 years ago

This was because I had accidentally left the "autoincrement" box checked. If you untick it the typeis generated correctly.

A nice feature to have would be the auto increment box to be unchecked and disabled automatically when you choose a non-numeric data type.

Thanks :)