create synonym command and pg_synonym table aren't exist

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • osman7king
    New Member
    • Sep 2010
    • 61

    #1

    create synonym command and pg_synonym table aren't exist

    when I try to create a synonym using the create synonym command as follow,
    Code:
    CREATE SYNONYM  table  T on PUBLIC.TABLE1
    I have the error like this:

    (syntax error at or near "SYNONYM").

    in addition, when I run the following query:
    Code:
    select * from pg_synonym
    also I have an error:
    ( relation "pg_synonym " does not exist )

    may be someone help me to solve these issues?

    many thanks.
  • rski
    Recognized Expert Contributor
    • Dec 2006
    • 700

    #2
    Postgres does not support synonyms.

    Comment

    Working...