Renaming a table is a very powerful feature of every database. SQLite3, as flexible as it is, has a feature to not cascade the renaming to foreign keys. Depending on how (and why) you use such feature, it can allow you for doing poweful things or ruin your database.
plpgsql can be used to build stored procedure and, with a few tricks, to consume data and translate it into other forms. It is also possible to generate a so known codice fiscale, the italian string that represents the tax payer number based on the person’s name, birth date and place.
This posts will show some concepts about how to generate the single pieces of the codice fiscale via
And why not? Let’s compare it to a
Adding a column with a default value requires a full table rewrite, and therefore it is often suggested to avoid the default value. However, it is possible to add the default value without having PostgreSQL perform the full table rewrite.