Right-click a console tab and navigate to Open In |. To open a console file in your file browser, do one of the following: In the To directory field, specify a new location for the file. Right-click a console file and select Refactor | Copy File…. Right-click a console file and select Delete. Select and drag console files to the directory.Įxpand a data source group that includes your console. Right-click a data source group where you want to create a new directory, select New | Directory. In the Project tool window ( View | Tool Windows | Project), navigate to Scratches and Consoles | Database Consoles. Group consoles under the data source directory Expand a data source group that includes your console, right-click the console file, and select Refactor | Rename ( Shift+F6). Open the Project tool window ( View | Tool Windows | Project) and navigate to Scratches and Consoles | Database Consoles. Right-click a console tab, and select Rename File. To rename a query console file, do one of the following: In the Database tool window ( View | Tool Windows | Database), click the Jump to Query Console… button ( ) and select a console that you want to open or create a new one.Ĭlick a data source, press F4, and select the console that you need. In the Project tool window ( View | Tool Windows | Project), navigate to Scratches and Consoles | Database Consoles |, double-click a console file. When a console is open, you can write SQL here, run it and get the result. Read more about the single session mode in Single session mode. You can work with just one connection for the data source and have all consoles use that same one connection. New console means a new connection to a data source. Right-click a data source and select New | Query Console.Ĭlick a data source, press Alt+Insert, and select Query Console.Ĭlick a data source, press Control+Shift+F10, and select New Query Console.Ĭlick a data source and press Control+Shift+Q. To create a console, use one of the following actions in the Database tool window ( View | Tool Windows | Database).Ĭ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, refer to 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, refer to 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. 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 database connection session is created automatically. On your machine, the query console files are stored in the consoles subdirectory of the IDE configuration directory.įor more information about working with query results in query consoles, refer to Query results. To open this folder, open the Project tool window ( Alt+1) 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 query consoles.Įach console creates a new connection session. When you create a data source, the data source's default query console is created automatically. You can write and execute SQL statements in query consoles the same way as you do it in terminal. Query or database consoles are SQL files that are attached to a data source. Open the Installed tab, find the Database Tools and SQL plugin, and select the checkbox next to the plugin name. Press Control+Alt+S to open the IDE settings and then select Plugins. If the relevant features aren't available, make sure that you didn't disable the plugin. This functionality relies on the Database Tools and SQL plugin, which is bundled and enabled in PhpStorm by default.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |