Unable to see character columns when querying pg_tables using oracle gateway dblink to postgresql 8.
edited Sep 12, 2013 6:44AM in Gateways, Oracle Lite, Oracle DB Mob. Server, TimesTen (MOSC) 2 commentsAnswered ✓
I have established a working dblink from oracle 11g to Postgresql 8.4 and 9.1. When I query a user table I receive character data; however, when I query pg_tables to get a listing of postresql tables, only the numeric columns show data. The tablename and schemaname are blank. How can I get the tablename to display? Below it the example I tried:
SQL> select * from "pg_tables"@POSTGRESQL2 where "tablename" not like 'pg_%';
s t t t hasindexes hasrules hastriggers
- - - - ---------- ---------- -----------
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
1 0 0
1 0 0
0 0 0
0 0 0
0 0 0
If I query a user created test table called foo I see the character data:
SQL> select * from "pg_tables"@POSTGRESQL2 where "tablename" not like 'pg_%';
s t t t hasindexes hasrules hastriggers
- - - - ---------- ---------- -----------
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
1 0 0
1 0 0
0 0 0
0 0 0
0 0 0
If I query a user created test table called foo I see the character data:
0