INSERT INTO SELECT: mix between select column and plain values?

28 Views Asked by At
INSERT INTO "ApiToken" ("ownerId", token, name) 
SELECT u.id, u."apiToken", "Default" 
FROM "User" u

Here, I'd like "name" to be set to a plain value "Default", but the query interprets this as "getting the Default column from User":

column "Default" does not exist

Is there any way I can achieve this?

0

There are 0 best solutions below