Understanding Zero as a Starting Position in SQL's SUBSTRING Functionality

How to Keep Auto-Generated Columns in PostgreSQL Even After Removing the Source Columns?