Export as SQL not working

[arturo-air]

I have tried to export with different options

• Selection: Complete, Row, Ranges, etc.
• Output format: CSV, Delimited Text, etc.

All of them worked, except SQL output format. Either I export as "Copy to clipboard" or "Export to file".

My operative system is Ubuntu 24, and I am using the AppImage version 0.1.27.

Thanks for the fantastic tool!

[invisal]

I have transfer this issues to studio repo. @keppere can you check this one?

[keppere]

I have transfer this issues to studio repo. @keppere can you check this one?

yes. I also need to add option to alias null value on export as well.

[keppere]

Hi @arturo-air,
Thanks for your feedback, to help debug this, could you share a bit more information?

• What database engine are you using (e.g., SQLite, MySQL, PostgreSQL, etc.)?
• Could you also provide a sample of the data and data types you're trying to export? I suspect there might be an edge case we’re not handling properly.

[arturo-air]

Database engine was Postgres.

For the data types, I wanted to provide you the SQL Preview of the table, and I realized that this one also doesn't work. So I'm going to export it from other database viewer.

-- Table: public.Media

-- DROP TABLE IF EXISTS public."Media";

CREATE TABLE IF NOT EXISTS public."Media"
(
    "Id" uuid NOT NULL DEFAULT uuid_generate_v4(),
    "CreatedBy" uuid,
    "CreatedDateUtc" timestamp without time zone NOT NULL DEFAULT (now() AT TIME ZONE 'UTC'::text),
    "UpdatedBy" uuid,
    "UpdatedDateUtc" timestamp without time zone,
    "MimeType" citext COLLATE pg_catalog."default" NOT NULL,
    "Path" citext COLLATE pg_catalog."default" NOT NULL,
    "Filename" citext COLLATE pg_catalog."default" NOT NULL,
    "Source" citext COLLATE pg_catalog."default",
    "IsSystem" boolean NOT NULL DEFAULT false,
    CONSTRAINT "PK_Media" PRIMARY KEY ("Id")
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public."Media"
    OWNER to postgres;

And also some example of the data:

insert into "public"."Media" ("CreatedBy", "CreatedDateUtc", "Filename", "Id", "IsSystem", "MimeType", "Path", "Source", "UpdatedBy", "UpdatedDateUtc") values ('9f9c12ee-197c-40da-b68a-0347be4bb72e', '2024-06-26 22:41:01.785445', '20240626224101_recipe_image_1015775.jpg', '003675df-178e-45a8-4154-08dc962e7475', true, 'image/jpeg', 'recipe/', NULL, NULL, NULL), ('9f9c12ee-197c-40da-b68a-0347be4bb72e', '2024-06-26 22:42:24.266843', '20240626224224_recipe_image_1015970.jpg', '0042db35-ed78-499f-41d5-08dc962e7475', true, 'image/jpeg', 'recipe/', NULL, NULL, NULL), ('9f9c12ee-197c-40da-b68a-0347be4bb72e', '2024-06-26 22:25:53.783898', '20240626222553_recipe_image_1013585.jpg', '0043d5c6-58d4-4170-39b9-08dc962e7475', true, 'image/jpeg', 'recipe/', NULL, NULL, NULL)