add context menus "Copy name" and "Copy FQN"

[ecerichter]

add context menus "Copy name" and "Copy FQN"

[adityatoshniwal]

Hi @ecerichter,
Did you try Ctrl+C/Cmd+C on the selected object?

[pravesh-sharma]

Copy FQN is not implemented yet.

[ecerichter]

Hi @ecerichter, Did you try Ctrl+C/Cmd+C on the selected object?

Thanks for your tip - it works, but is kind of inconsistent:

• Ctrl+C over a table returns "public.mytable"
• Ctrl+C over a column returns "MyColumnName"

As pointed by pravesh-sharma, there is not Copy FQN - but current behavior is kind of mixed.

I've tested almost all types of objects, and discovered the following pattern:

Ctr+c over Database object: only name
Ctr+c over intermediate nodes: only name
Ctr+c over schema direct childs (tables, functions, trigger functions, sequences): schema+name
Ctr+c over columns: only name
Ctr+c over indexes: only name

That's are all my findings.

[adityatoshniwal]

Hi @ecerichter,
The name is generated to make it SQL friendly. Generally in a query, a fully qualified column is not used. Its simply the column name. For tables, a fully qualified name is used. It is intentional.