Sharing formatting profilesĭbForge Studio for PostgreSQL allows you to share formatting styles with your colleagues to enforce common layout and coding standards within your team. Under the Active Format Profile menu option switch to a profile you want. Select and right-click a code segment you want to format.Ģ. To apply a different formatting profile for certain segments of code in a query:ġ. With dbForge SQL formatting tool built-in Studio for PostgreSQL you can switch between formatting profiles within one SQL document. To edit a profile, select it and click Edit Profile. To make a profile active, select it and click Activate. Your active profile is the formatting profile that is highlighted and given in bold. To create your own profile, click New Profile, make the necessary configurations, and click OK to save them. Then in the menu that opens, select Profiles under the Formatting menu option.ĭbForge Studio for PostgreSQL has one default profile. To create or edit a formatting profile, on the Tools menu, click Options. Customizing your formatting profileĪ formatting profile comprises a saved set of options for your SQL document layout.

On the Edit menu, under the Advanced menu option select Format Selection.įormatting SQL scripts and queries has never been easier.

Then under the Format menu option select Format Selection.

Select and right-click the fragment you want to format.

To format a certain code fragment, do one of the following:

On the Edit menu, under the Advanced menu option select Format Current Statement.

Right-click the SQL query body and then under the Format menu option, select Format Current Statement.To format the current statement, do one of the following: On the Edit menu, under the Advanced menu option select Format Document.Right-click the SQL query body and then under the Format menu option, select Format Document.To format the code of a document, do one of the following: Make the necessary configuration changes and click OK.

Two tabs are available under the Formatting option: General, where you can tune your formatting, and Profiles, where you can customize the existing profiles or add the new ones.Ĥ. In the dialog box, that opens click Formatting.ģ. To configure formatting options and customize formatting profiles:Ģ. Taking care of code formatting, syntax check, and code completion, the PostgreSQL Code Formatter feature built-in dbForge Studio for PostgreSQL will let you stay focused on the task. It is highly important to retain code readability at the stage of writing it.

Pgadmin 4 query format