Search
 
SCRIPT & CODE EXAMPLE
 

SQL

alter sequence postgres

ALTER SEQUENCE eadmodulo_id_seq RESTART WITH 8;
Comment

postgresql alter table sequence

alter sequence your_sequence restart with 1000;
Comment

alter or change postgresql sequence counter

SELECT setval('payments_id_seq', 21, true);  # next value will be 22
Comment

PREVIOUS NEXT
Code Example
Sql :: insert column with default value in sql 
Sql :: ubuntu stop mysql from starting on boot 
Sql :: your password does not satisfy the current policy requirements 
Sql :: syntax for changing column size in mysql 
Sql :: adding a default constraint to an existing column in sql 
Sql :: mysql slave status 
Sql :: postgresql select all column names 
Sql :: oracle truncate partition 
Sql :: psql list rules 
Sql :: use cases condition in sql query laravel 
Sql :: get count by weekly pivot table sql server 
Sql :: oracle extract minute from date 
Sql :: timestamp in sqlite 
Sql :: influxdb export to csv 
Sql :: mssql reset auto increment 
Sql :: show table status command in mysql 
Sql :: check mysql timezone 
Sql :: hexadec to sql REDSHIFT 
Sql :: execution plan oracle 
Sql :: mysql on terminal mac 
Sql :: postgresql select as and fwhwere by this field 
Sql :: oracle nls session 
Sql :: output to file mysql 
Sql :: select * from table where name like 
Sql :: install mysql 8 ubuntu 18.04 
Sql :: oracle user quota unlimited 
Sql :: date_add mysql 
Sql :: sql update alias 
Sql :: postgresql get year 
Sql :: create sequence if not exists postgres 
ADD CONTENT
Topic
Content
Source link
Name
7+2 =