473,395 Members | 1,766 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

create synonym command and pg_synonym table aren't exist

when I try to create a synonym using the create synonym command as follow,
Expand|Select|Wrap|Line Numbers
  1. CREATE SYNONYM  table  T on PUBLIC.TABLE1
  2.  
I have the error like this:

(syntax error at or near "SYNONYM").

in addition, when I run the following query:
Expand|Select|Wrap|Line Numbers
  1. select * from pg_synonym 
  2.  
also I have an error:
( relation "pg_synonym" does not exist )

may be someone help me to solve these issues?

many thanks.
Oct 9 '10 #1
1 7541
rski
700 Expert 512MB
Postgres does not support synonyms.
Oct 9 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Robert Rae | last post by:
OS XP Pro SP2 MYSQL Ver: 5.0.0-alpha nt Whenever I view a table or run a query in the Control Center (0.9.4-beta) I get the following error: ERROR 1146: Table 'shipnet.1' doesn't exist ...
0
by: Domenico Briganti | last post by:
Hello! Exist a tool for create a windows form for insert/modify/delete row in a table from a table schema? Thank Domenico
0
by: DanPerlman | last post by:
Hi, I am using the following to write data from an access table to a postgres table. I need to create an index on the "partnumber" field in the Bpb (odbc pg database) so I can seek on that...
1
by: Joe Philip | last post by:
I created a file called data.del using export like this: export to data.del of del select * from sy9.c001 Now, I want to import this data to a different database into a different table. This...
4
by: Mythran | last post by:
I have the following code: public static void Main() { DoIt(); } private void DoIt() {
4
by: M Bourgon | last post by:
I have two SPs, call them Daily and Weekly. Weekly will always call Daily, but Daily can run on its own. I currently use a global temp table because certain things I do with it won't work with a...
2
by: Guy Moseley | last post by:
Hi all, Could someone please point me in the right direction! I am in the process of creating an Ms Access db and as part of this use VBA in a form to create a table based on the input to the...
17
abdoelmasry
by: abdoelmasry | last post by:
Hi Men i have real problem using mysql database i make database for my site with mysql it have very important data but i think the database tables corrupted
2
by: kilo | last post by:
Hey.. I need someone hwo can help me making my sql table.. I have no php skills. I have payed for a php program that shoud make dictation for people that have some problems reading danish.. with...
3
by: moltendorf | last post by:
I copied the files from my "test" database on my old server (MySQL was not running) to my new server ("./mysql/data/test" folder), and after starting the server, SHOW TABLES; shows all of the tables...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.