Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQL Comments not imported correctly in PostgreSQL format #367

Open
psychowood opened this issue May 28, 2024 · 0 comments
Open

SQL Comments not imported correctly in PostgreSQL format #367

psychowood opened this issue May 28, 2024 · 0 comments
Labels
bug Something isn't working

Comments

@psychowood
Copy link

Describe the bug
I'm not sure if this is actually a BUG or rather a missing feature, but exporting SQL in postreSQL format works, while importing is not working, adding a "ON" comment to the table and no comments to the columns.

To Reproduce
Steps to reproduce the behavior:

  1. Create a new ER DIagram
  2. Add a new Table, add some comments to both table name and columns

image

  1. Select Database -> PostgreSQL
  2. Export in SQL Format
  3. Delete the table
  4. Import the SQL file
  5. Get a static "ON" comment to the table name and no comments to the columns:

image

Expected behavior
Exported comments present in the sql file are imported in the schema.

Browser (please complete the following information):

  • OS: macOS
  • Browser firefox
  • Version 126.0

VSCode (please complete the following information):

  • OS: macOS
  • VSCode version: 1.89.1
  • Extension Version: v1.0.20

Additional context
MariaDB format seems to work for the same table

@psychowood psychowood added the bug Something isn't working label May 28, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant