Syntax error while creating table in PostgreSQL 8.1

Question

I have a syntax error in this query:

CREATE TABLE test (LIKE original_table INCLUDING INDEXES);

ERROR : syntax error at or near "INDEXES"

I am using PostgreSQL 8.1 version. Where is the issue in my query?

Why you are you using such an outdated version? You should really upgrade to a version that is under maintenance. — user330315
– user330315, Commented Jun 15, 2015 at 13:05

Colonel Thirty Two · Accepted Answer · 2015-06-15 13:02:06Z

2

You'll either have to upgrade to at least 8.3 or create the indices manually.

answered Jun 15, 2015 at 13:02

27k9 gold badges52 silver badges94 bronze badges

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

1 Answer 1