BUG #6478: Foreign tables not displayed

On Mon, 20 Feb 2012 16:32:27 +0000, roman@chmela.sk wrote:

The following bug has been logged on the website:

Bug reference: 6478
Logged by: Roman Chmela
Email address: roman@chmela.sk
PostgreSQL version: 9.1.2
Operating system: 1) Windows 7 pro, 2) Ubuntu
Description:

Hello
I have setup successfully foreign table, fully functional, retrieving

data

from external csv file:
create extension file_fdw;
CREATE SERVER file_server FOREIGN DATA WRAPPER file_fdw;

CREATE FOREIGN TABLE my_names (
name text,
surname text
) SERVER file_server
OPTIONS (format 'text', filename 'c:\xxx\my_names.csv', delimiter ';',

null

'');

-----------------
Problem:
-----------------
- this table is not listed among tables (using pgadmin)

-------------------
Possible solution?
-------------------
CREATE OR REPLACE VIEW pg_tables AS
SELECT n.nspname AS schemaname, c.relname AS tablename,
pg_get_userbyid(c.relowner) AS tableowner, t.spcname AS tablespace,
c.relhasindex AS hasindexes, c.relhasrules AS hasrules, c.relhastriggers

AS

hastriggers
FROM pg_class c
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_tablespace t ON t.oid = c.reltablespace
--WHERE c.relkind = 'r'::"char";
WHERE c.relkind in ('r'::"char",'f'::"char");

Foreign tables have their own node. This node is not displayed by default.
You need to go the preferences dialog, select the Browser tab, and check
the "Foreign tables" checkbox. And reconnect to your server. That should
display a new node with all foreign tables.

BTW, if you find bugs or have issues with pgadmin, you shouldn't send them
here. Use the pgadmin-support mailing list instead.

--
Guillaume
http://www.postgresql.fr
http://dalibo.com