ERROR:syntax error at or near "%" in postgresql

Question

Please i am trying to create a table in postgres using pgadmin. After selecting from the "Inherit from" drop down, i am getting the following error

ERROR: syntax error at or near "%"
LINE 2: INHERIT public.%22Staff%22;

What happens when you take out the double quotes around "Staff"? — Alex V
– Alex V, Commented Nov 28, 2019 at 18:30

Bergi · Accepted Answer · 2019-11-28 20:19:51Z

3

This is a bug in pgAdmin4 as it doesn't appear to handle quoted object names, at least for inheritance.

I have now reported this bug to the PgAdmin community.

In the meantime, you may wish to take the SQL it generates (visible on the SQL tab) and manually edit then run it, replacing %22 with ". Or you could use table names without quoting, which will cause it to lose it's casing, so that may or may not be an issue for you.

Disclosure: I am an EnterpriseDB (EDB) employee.

edited Nov 28, 2019 at 20:19

Bergi

671k162 gold badges1k silver badges1.5k bronze badges

answered Nov 28, 2019 at 18:32

Thom Brown

2,0698 silver badges14 bronze badges

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

1 Comment

Thom Brown Over a year ago

You won't be able to edit the SQL in the SQL tab, but you can copy and paste it into the Query Editor. That's the lightning bolt icon button on the main window, or go to Tools > Query Tool.

Collectives™ on Stack Overflow

ERROR:syntax error at or near "%" in postgresql

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related