Serial Postgres Alter
I have a database in Postgresql, which was migrated from SQL Server (only data).
On SQL Server, a table from this database has these columns:
When upgrading a field / changing it's type using pgsql:changeField, it's impossible to make a field a serial, bigserial, or numeric. This appears to be because of confusion between the typecast that is required to do the data-conversion and the field-type we are creating. As is currently stands,. PostgreSQL SELECT primary key as “serial” or “bigserial”. Standard behaviour in executing multiple alter statements in Postgres. Hot Network Questions Ex-contractor published company source code and secrets online How to vertically align the three columns of my table top, top, middle How does The Fools Guild make its money?
where measure_id is auto-incremental primary key, datum is datetime and measure is float.
After migration in Postrgresql, measure_id is column of type bigint.
How can I change this column (measure_id) to bigserial and assign it as primary key, now that my table is full of data?
1 Answer
Nozzle pro download crack for gta. Create a sequence and use it as the default value for the column:
That essentially what serial does.
Postgres Alter Table Column
See the manual for details:
http://www.postgresql.org/docs/current/static/datatype-numeric.html#DATATYPE-SERIAL
Postgres Alter Type
a_horse_with_no_namea_horse_with_no_name