Skip to content

P
Postgres FD Implementation
Switch branch/tag
Find file BlameHistoryPermalink
  • Marc G. Fournier's avatar
    · a00a1a56
    Marc G. Fournier authored 
    bring it all into -current again
    a00a1a56
view_table_structure.hlp 1.3 KB
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 
.pgaw:Help.f.t insert end \
"View and change table structure" {bold} "

   Select the Tables tab from the main window , select the desired table and press the \"Design\" button. You will get a tabbed dialog containing general information for the table, table structure, index information and permissions.
   
   You will be able to add new fields, rename the existing ones and add new indexes. In order to add a new index, select the fields that will be included in the index (multiple selections with shift-click) and press the \"Add new index\" button.
   
   A confirmation form will be displayed. The index name will be asigned by default by concatenating using underscore the table name with the fields names but you can change it as you will. Checking the \"Is unique?\" check box will force the creation of a unique index.
   
   You can inspect the properties of a index by selecting it from the list of defined indexes. You can also delete one of them by selecting the index and then pressing the \"Delete index\" button.\
You can cluster an index fo the table, more information on " {} "cluster SQL command" {link cluster} "

   Through \"Permissions\" tab you can assign new permissions for the table or alter the existing ones. See also " {} "GRANT" {link grant} " and " {} "REVOKE" {link revoke} " SQL commands."