Injected SQL statements

Temporarily inject a language

1. Place the cursor inside a string literal, tag, or attribute, in which you want to inject a language and press Alt+Enter (or use the intention action icon ).

2. Select Inject language or reference and choose the language you want to inject.

Open a code fragment in the dedicated editor section

1. Position the caret within the injected code piece and press Alt+Enter (or use the intention action icon ).

2. Select Edit <language ID> Fragment.

   PyCharm will open a dedicated editor section for editing the code with the injected language. This editor provides full code assistance, including code completion, inspections, intentions and code style actions.

   

Inject PL/Python code

You can have PyCharm highlight PL/Python language injections for PostgreSQL in CREATE FUNCTIONand CREATE PROCEDURE operators.

1. Define plpythonu explicitly as the language of the function.

2. Make sure the injected Python code is indented relative to the containing function.

note

PyCharm doesn't yet provide completion for plpy attributes, SD, GD, or TD keys.

Cancel injections

1. Place the caret at the code fragment and press Alt+Enter (or use the intention action icon ).

2. Select Uninject language or reference.

Configure injection rules

You can configure language injection rules on the Editor | Language Injections page of the IDE settings Ctrl+Alt+S.

All pre-defined injection rules are configured for the Built-in scope. In other words, they are global (and therefore available in all PyCharm projects). Custom rules can be configured for the IDE or for one project only. To change the scope of custom injections, use the Move to Project/IDE Scope icon .

To configure custom injection rules, click the Add icon to add a new rule, or copy a predefined rule and change its settings.