(For more details, see Nolo's article Prenuptial Agreements -- What the Law Allows.) If You Don't Make a Prenup. If you don't make a prenuptial agreement, your state's laws determine who owns the property that you acquire during your marriage, as well as what happens to that property at divorce or death.
When you add a new column to the table, PostgreSQL appends it at the end of the table. PostgreSQL has no option to specify the position of the new column in the table. To add multiple columns to an existing table, you use multiple ADD COLUMN clauses in the ALTER TABLE statement as follows: 1.
Adding additional geometry column in PostGIS. I'm importing many sets of geodata into PostGIS, and they have different SRID's. (Some have EPSG:3857, some EPSG:4326, some something else). I'd like to create an additional geometry column, eg. the_geom_mercator with SRID EPSG:3857, and also keep the original geom column in whatever SRID it came in.