1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
|
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<link rel="STYLESHEET" type="text/css" href="pgadmin3.css">
<title>pgAdmin Query Tool</title>
</head>
<body>
<H3>pgAdmin Query Builder</H3>
<center><img src="images/querybuilder.jpg"></center>
<P>The Query Builder allows you to build SELECT queries graphically.
Queries can then be executed, or EXPLAINed using the same threaded
query engine as the <a href="query.html">Query Tool</a>
</P>
<P>To build a query, first press the Add Table/View button on the toolbar.
Select one or more tables or views, and click the <i>OK</i> button to add
tem to the workspace.
</P>
<P>To add joins between relations, using your mouse simply drag and drop a column from
the parent relation on the appropriate column in the child relation. In the resulting
dialogue box, confirm the options and make any required changes, then click the
<i>Add</i> button to add the join.
</P>
<P>To add columns to output or restrict the query, simply double-click them. Any
selection criteria can be added as required in the column grid.
</P>
<P>Once the query is built, click the <i>Execute</i> button to run it, or the
<i>Explain</i> button to view the query plan. You may view the output, SQL,
messages and session history on the appropriate tab.
</P>
</BODY>
</HTML>
|
