Menu

#1230 Cannot copy tables if column name is version or level

SQuirreL
open
nobody
None
5
2016-01-19
2016-01-19
Ioan Stan
No

Hi,

I'm using the latest version (3.7) of Squirell SQL and it's a very good software. I have encountered a bug however: when I try to copy tables from one PostgreSQL database to another some tables are not copied because of a column name cannot be used as a column name.

I've attached an image. The column name is version in this case but also 'level' seems to cause the bug.

I think this can be solved by esccaping column names in the DDL so this wil work for PostgreSQL.

If this is not possible across clients you could allow the user to continue without copying the table. The current behaviour is that it fails the whole process and I have to select tables by hand.

Thanks,

1 Attachments

Discussion


Log in to post a comment.

MongoDB Logo MongoDB