Syntax error at or near AS integer when creating a sequence

Question

I am getting "error at or near AS integer" in below code when I am trying to execute with psql.

CREATE SEQUENCE public.auth_group_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

The above sql statement is from the backup file of local machine postgres version 11 and executing in EC2 postgres version 9.3. I am new to postgres and getting no idea as the sql is generated by postgres only so it should work with psql. Thanks in advance.

user330315 · Accepted Answer · 2019-01-12 21:26:46Z

13

Postgres 9.3 (which is no longer supported) did not support the AS data_type option. This was introduced in version 10.

You could try using pg_dump from your 9.3 installation to do the dump, but I am not sure if that works.

answered Jan 12, 2019 at 21:26

user330315

Sign up to request clarification or add additional context in comments.

Comments

Stanislav Savchuk · Accepted Answer · 2020-06-22 10:16:48Z

4

Some workaround that works for me. In this case, you simply have to remove AS integer from the dump file.

sed 's/    AS integer$//g' your_dump_file.out > tmp.out
mv tmp.out your_dump_file.out

edited Jun 22, 2020 at 10:16

answered Feb 26, 2020 at 8:47

Stanislav Savchuk

414 bronze badges

Collectives™ on Stack Overflow

Syntax error at or near AS integer when creating a sequence

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related