Copy insert doesn't include schema #197

Closed
jspeis opened this Issue Mar 18, 2016 · 3 comments

Comments

Projects
None yet
3 participants
@jspeis

jspeis commented Mar 18, 2016

Copy insert in Postico 1.0.5 does not include the schema of the table when copying e.g.

screen shot 2016-03-18 at 2 47 30 pm

e.g. if I have a table like my_schema.my_tables

the SQL just has: INSERT INTO "my_table" ... but should have: INSERT INTO "my_schema.my_table"

@qwesda

This comment has been minimized.

Show comment
Hide comment
@qwesda

qwesda May 24, 2016

+1

This would be very nice. The behaviour should be to include the fully qualified table name regardless of the current search_path setting.

qwesda commented May 24, 2016

+1

This would be very nice. The behaviour should be to include the fully qualified table name regardless of the current search_path setting.

@jakob jakob added started done and removed started labels Aug 26, 2016

@jakob

This comment has been minimized.

Show comment
Hide comment
@jakob

jakob Aug 26, 2016

Owner

Done. Will be in next version. Development build for testing:
https://eggerapps-downloads.s3-eu-west-1.amazonaws.com/postico-1500.zip

Owner

jakob commented Aug 26, 2016

Done. Will be in next version. Development build for testing:
https://eggerapps-downloads.s3-eu-west-1.amazonaws.com/postico-1500.zip

@qwesda

This comment has been minimized.

Show comment
Hide comment
@qwesda

qwesda Aug 27, 2016

Have testes it and it works as expected, thanks! The Copy JSON variant is also very welcome.

qwesda commented Aug 27, 2016

Have testes it and it works as expected, thanks! The Copy JSON variant is also very welcome.

@jakob jakob closed this Nov 15, 2016

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment