Contents
- Getting Started
- External database for pgAdmin user settings
- Connecting To A Server
- Managing Cluster Objects
- Managing Database Objects
- Cast Dialog
- Collation Dialog
- Domain Dialog
- Domain Constraints Dialog
- Event Trigger Dialog
- Extension Dialog
- Foreign Data Wrapper Dialog
- Foreign Server Dialog
- Foreign Table Dialog
- FTS Configuration Dialog
- FTS Dictionary Dialog
- FTS Parser Dialog
- FTS Template Dialog
- Function Dialog
- Language Dialog
- Materialized View Dialog
- Package Dialog
- Procedure Dialog
- Publication Dialog
- Schema Dialog
- Sequence Dialog
- Subscription Dialog
- Synonym Dialog
- Trigger Function Dialog
- Type Dialog
- User Mapping Dialog
- View Dialog
- Creating or Modifying a Table
- Management Basics
- Backup and Restore
- Developer Tools
- Processes
- pgAgent
- pgAdmin Project Contributions
- Release Notes
- Licence
Synonym Dialog¶
Use the Synonym dialog to substitute the name of a target object with a user-defined synonym.
The Synonym dialog organizes the development of a synonym through the General tab. The SQL tab displays the SQL code generated by dialog selections.
![Synonym dialog general tab](/https/www.pgadmin.org/static/docs/pgadmin4-7.8-docs/_images/synonym_general.png)
Use the fields in the General tab to identify the synonym:
Use the Name field to specify the name of synonym. The name will be displayed in the pgAdmin tree control.
Select the name of the schema in which the synonym will reside from the drop-down listbox in the Schema field.
In the definition panel, identify the target:
![Synonym dialog general tab](/https/www.pgadmin.org/static/docs/pgadmin4-7.8-docs/_images/synonym_definition.png)
Use the drop-down listbox next to Target Type to select the type of object referenced by the synonym.
Use the drop-down listbox next to Target Schema to select the name of the schema in which the object resides.
Use the drop-down listbox next to Target Object to select the name of the object referenced by the synonym.
Click the SQL tab to continue.
Your selections and entries in the Synonym dialog generate a SQL command.
![Synonym dialog sql tab](/https/www.pgadmin.org/static/docs/pgadmin4-7.8-docs/_images/synonym_sql.png)
The example creates a synonym for the emp table named emp_hist.
Click the Save button to save work.
Click the Close button to exit without saving work.
Click the Reset button to restore configuration parameters.