PyCharm 2022.1 Help

Modify

The following topic shows various ways to modify tables in PyCharm.

Modify a

  1. In the Database tool window (View | Tool Windows | Database), right-click a and select Modify.

  2. In the Modify Table dialog, specify the settings that you need.

Starting with PyCharm 2022.1, you can change database-specific parameters of a . The IDE generates fields for the new Modify dialog automatically according to the properties received during the introspection. For example, by using this dialog in PostgreSQL, you can add and edit column check constraints.

Modify a database-specific parameters of an object

  1. In the Database tool window (View | Tool Windows | Database), right-click a and select Modify (New UI).

  2. In the Modify dialog, specify object settings that you need.

Enable read-only mode for a table

To protect a table from accidental modifications in the data editor, you can make the table read-only.

  • To enable read-only mode, click the Click to toggle the read-only attribute icon (The Click to toggle the read-only attribute icon) in the lower-right corner of the editor.

To turn off read-only mode, click the Click to toggle the read-only attribute icon again.

Enable the read-only mode for a table

Show descriptions for databases and tables

  • To enable descriptions for databases and tables, navigate to View | Appearance | Details in Tree View.

    To add comments for tables, select a table and press Ctrl+F6. In the Comment text field, add a table description.

    To add comments for a database, open database settings Ctrl+Alt+S and add a database description in the Comment text field.

    Show descriptions for databases and tables

Configure GRANT privileges for tables

  1. In the Database tool window (View | Tool Windows | Database), right-click a table and select Modify Table.

  2. On the Grants tab, click the Add button (the Add button).

  3. In the user field, type the username. You can press Ctrl+Space to use code completion in this field.

  4. Click the grant field, from the drop-down near each privilege, select Grant or Grant with option. The Grant with option privilege means that a user can grant to or revoke from other users those privileges.

    Configure privileges and roles for user accounts

Productivity tips

Modify a table from the data editor

You can modify a table while you edit table data.

  1. Double-click a table to open it in the data editor.

  2. Press Ctrl+F6.

  3. Modify data and click Execute.

  4. Press Ctrl+F5 to reload the page.

    Modify a table from the data editor
Last modified: 17 March 2022