how to change xtknewid sequence to custom dedicated sequence on custom schema

[DishaSharma]

@isahore 

@AndreaBriceno

@ParthaSarathy

@ParthaSarathy 

@ParthaS 

@AkshayAnand 

@Craig_Thonis 

@Manoj_Kumar_ 

@Amine_Abedour 

@Marcel_Szimonisz

@DavidKangni 

@Amit_Kumar 

@ShashankNigam02

@Ganesh5067

@Jonathon_wodnicki

@ParthaSarathy

@ParthaSarathy 

@ParthaS 

@AkshayAnand 

@Craig_Thonis 

@Manoj_Kumar_ 

@Amine_Abedour 

@Marcel_Szimonisz

@DavidKangni 

@Amit_Kumar 

@ShashankNigam02

@Ganesh5067

@Jonathon_wodnicki

hi all, one of our custom schema is using xtknewid sequence but we want to change it from

 xtknewid sequence to custom dedicated sequence on custom schema

how to change ?please help

[AnirbanSi · Accepted solution]

you can create a new sequence by adding the pkSequence="sequenceName" in the element tag of the schema & autopk=true

Also you need to create sequence in database level 

CREATE SEQUENCE sequenceName START 101;

https://www.postgresql.org/docs/current/sql-createsequence.html