CREATE SYNONYM v16
CREATE SYNONYM — Define a new synonym.
CREATE SYNONYM defines a synonym for certain types of database objects. EDB Postgres Advanced Server supports synonyms for:
- Materialized views
- Stored procedures
- Stored functions
- Objects that are accessible through a database link
- Other synonyms
The name of the synonym. A synonym name must be unique in a schema.
The name of the schema where the synonym resides. If you don't specify a schema name, the synonym is created in the first existing schema in your search path.
The name of the object.
The name of the schema where the referenced object resides.
The name of the database link through which you access an object.
REPLACE clause to replace an existing synonym definition with a new synonym definition.
PUBLIC clause to create the synonym in the
public schema. The
CREATE PUBLIC SYNONYM command, compatible with Oracle databases, creates a synonym that resides in the
This is a shorthand way to write:
Access to the object referenced by the synonym is determined by the permissions of the current user of the synonym. The synonym user must have the appropriate permissions on the underlying database object.
Create a synonym for the
emp table in a schema named