Setting the table column order
Prev Chapter 3. Using PSQL Next

Setting the table column order

In optimisation process it is often required to make certain column order in generated tables.

It is possible to do it using PSQL:

  1. Select the required tables in the tree.
  2. On the right side the table columns together with their ordering is shown. Ammend values to get required ordering.

Figure 3.1. Column ordering example

Column ordering example
Once changes are made save the file (menu File->Save).

Prev Up Next
Symbols in the table tree Home Creating and modifying indexes