![]() To select multiple rows, click numbers in the gutter. To save a new row, click Submit button ( ).įor more information about working with rows, refer to Tables. Terminate execution of the current statement or statements. Select, pause, or disable update interval for the current table. Also, use the Reload Page button when you want to apply a new page size limit setting after its change. Reload data for the table view to synchronize the data that you see in the editor with the contents of the database. Alternatively, to disable the page size restriction, clear the Limit page size to checkbox. ![]() In the Limit page size to field, type a new size of a result set page. Alternatively, open settings ( Ctrl+Alt+S) and navigate to Database | Data Editor and Viewer. ![]() To change the size of a result set page, click the Change page size button and select the size. You can change it here by clicking and selecting the necessary limit or in settings. You can see the limit between the navigation buttons. If all the rows are currently shown, navigation icons and the corresponding commands are inactive. If this number is less than the number of rows in the table, only a subset of all the rows is shown at a time. Use navigation icons and corresponding commands for switching between pages that show the table data and change the page size.Ī number of rows that you see on the toolbar are referred to as a result set page. Most of the available functions are accessed by means of controls on the toolbar, context menu commands for the data cells, and associated keyboard shortcuts. You can also navigate between related rows, between subsets of rows, or go to a specified row.įor full information on these and other features, refer to Rows. Manipulate the rows by adding, deleting, cloning them, and so on. For MongoDB, the default extractor is always JSON.įor more information about data extractors, refer to the corresponding page.įor more information about exporting data in DataGrip, refer to Export data. The last selected extractor becomes the default one for newly opened editor tabs. You can use a built-in data extractor, configure a custom extractor that is based on CSV or DSV format, and create a custom data extractor using a provided API. Each time you export or copy data, the copied data format is defined by the selected data extractor. Export dataĭataGrip uses data extractors to export data in various formats to a file or the clipboard. Use one of the following ways to filter data:Įnter a filtering query into the corresponding field.įor full information, refer to Filter data. You can also change the setting and sort data on the client side.įor full information, refer to Sort data. By default, each time you sort data, DataGrip sends a new ORDER BY query to the database. ![]() You can sort data by clicking a column's header, or by entering a sorting query into the corresponding field. You can also select to ignore the extra column in either one of the objects.įor full information, refer to Compare the data of database objects. For comparison, you can define how many columns should differ to consider two columns equal. Compare dataĬompare the data of two database objects. Use the value editor to view and edit contents of a separate cell.įor full information on data view modes and other features, refer to View data. In the Table mode, you can also transpose the view. You can browse and edit data in three modes: Table, Tree, Text, and Transpose. If you want to edit only part of the data, select the necessary fragment inside the file.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |