To create a console, use one of the following actions in the Database Explorer ( View | Tool Windows | Database Explorer).Ĭlick a data source and select File | New | Query Console. Work with console files Create a query console If the executed statement does not retrieve data, results are displayed in the Output tab. For more information about creating custom titles for result tabs, see Use custom titles for tabs with results. If the executed statement retrieves data (for example, SELECT), results are displayed in the Result tab that has a title of a qualified table name. For more information about the Services tool windows, see Services tool window. The Services tool window displays available connection sessions, Output and Result tabs. When you execute a statement, the Services tool window opens. Read more about the editor in Editor basics. The code editor is where you compose your SQL statements using the resolve modes and coding assistance features, and execute them against the associated data source.įind the code editor toolbar controls in Code editor controls. Read more about managing sessions in Managing connection sessions. You can change the console session to actor or create a new session and attach the console to it. In the following example, the PostgreSQL console is associated with the guest.public schema of a data source and connected to it via the console connection session. You can create new connection sessions and attach your console to existing ones in the console toolbar. Database connection sessionįor each console, a data source connection session is created automatically. To learn about the New UI, refer to the corresponding topic.įor information about working with query results in query consoles, refer to Query results. Starting from version 2023.1, the New UI is available. In the video, the DataGrip user interface is Classic UI. ![]() The following video gives a short overview of query consoles in DataGrip. On your machine, the query console files are stored in the consoles subdirectory of the IDE configuration directory. To open this folder, open the Files tool window ( Alt+2) and navigate to Scratches and Consoles | Database Consoles. If you do not want to create new connections, enable single session mode.Īll the created query consoles are located in the internal Database Consoles directory. If necessary, you can create additional consoles. When you create a data source, a query console is created automatically. You can use a query console in the same way as you use a terminal, by typing and running your code. Unlike scratch files, consoles are attached to a data source. Query or database consoles are SQL files in which you can compose and execute SQL statements.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |