removing "serial" from table definitions.

[Marc Mamin <M.Mamin@xxxxxxxxxxxx>]

Hi,

Is there  a way to change a data type from serial to int?

I tried with :

  ALTER TABLE "admin".db_jobs ALTER COLUMN id TYPE int USING id::int;

But this seems not to change anything, as if Posgres woud consider the statement as a no-op.

 

My problem is that "serial" is not exported with pg_dump.

Creating a db from the dump will hence result into a different table definition (which is equivalent tough)

 

We are trying a transfer/migration tool on Azure, that check the table definitions between the source and target before starting the data transfer, and it blocks on that difference.

 

best regards,

Marc Mamin