GoLand
 
2023.2
Shortcuts: Windows
Get GoLand
  1. Integrated tools
  2. Database tools and SQL
  3. File management
  4. User files

User files

Last modified: 14 August 2023

User files are the files that are stored on your machine or any other place you have access to. In GoLand, they are available to work with in the Project tool window .

You can view, edit, create, and delete the SQL files.

Create an SQL file

  1. In the Project tool window ( View | Tool Windows | Project) , right-click the directory in which you want to create an SQL file and select New | File.

  2. In the New File dialog, specify the filename with the SQL extension.

Managing directories

For a directory to appear in the Project tool window , attach it to your project.

Attach a directory with SQL files

  1. Click File | Open.

  2. Navigate to the folder that you want to attach.

  3. Click Open.

  4. In the Open Project dialog, click Attach.

Attach a directory to the project

Detach a directory with SQL files

  • In the Project tool window (View | Tool Windows | Project), right-click a directory and select Detach Directory.

    Detach a directory with SQL files

Run SQL files

SQL files are run against the selected databases or schemas using run configurations. To run an SQL file, you can either create a new run configuration, or edit an existing one.

For information about how to run an SQL files from your machine, see Run SQL files.

Configure a dialect for SQL files

For better coding assistance, assign an SQL dialect to an SQL file. An SQL dialect is a DBMS-specific version of SQL.

GoLand lets you specify the SQL dialect for an individual file or all SQL and DDL files that can be stored in a directory, in your project, or on your computer.

Specify a dialect for a single SQL file

  1. Click the dialect list, which is in the upper-right corner of the window.

  2. Select a dialect from the dialect list.

    Specify an SQL dialect

Specify a dialect for multiple SQL files

  1. Open settings by pressing CtrlAlt0S and navigate to Languages & Frameworks | SQL Dialects.

  2. Click the Add button the Add button and select directories or files for which you want to change a dialect.

  3. Click Open.

  4. Click the SQL Dialect cell and select the necessary dialect.

  5. Apply changes and click OK.

Images

View images in GoLand

  • In the Project tool window ( View | Tool Windows | Project) , find and select the image file.

    Alternatively, position the caret at the reference to the image in the editor and press Ctrl0B.

  • To preview an image in a popup instead of in a separate tab, select the reference to it and press CtrlShift0I.

View images in an external editor

  • In the Project tool window ( View | Tool Windows | Project) , right-click the image file and select Jump to external editor.

    Alternatively, press CtrlAltF4.

    GoLand opens the image in the editor that is used in your OS by default. You can configure another image editor in which the IDE will open files.

Change the default external editor

  1. Right-click an image in the editor and select Edit Path to External Editor from the context menu.

    You can also press CtrlShift0A and type Edit Path to External Editor.

  2. In the Path to External Editor dialog, specify the path to the application in which you want to open images and click Save.

    Specifying the path to an external editor

Toolbar and context menu actions

Action

Description

Show Chessboard

Select this checkbox to have transparent pieces of images shown as a chessboard.

Show Grid

Select this checkbox to have a grid displayed when reviewing image files.

Zoom In

Click the zoom the image in.

Zoom Out

Click the zoom the image out.

Actual Size

Click to view the image in its actual size.

Fit Zoom To Window

Click to make large images fit the window size.

Show Color Picker

Open the Color Picker dialog.