On mån, 2010-12-13 at 14:45 +0900, Shigeru HANADA wrote: > Simple FDWs such as File FDW might not have concept of "user" on > remote side. In such case, it would be enough to control access > privilege per local user with GRANT/REVOKE SELECT statement.
Right. But it depends on the implementation. You could, for example, imagine a "userdir" FDW that reads from users' home directories. > To allow omitting column definitions for that purpose, a way to create > ero-column tables would have to be provided. New syntax which allows > FDWs to determine column definition would be necessary. > > ex) > -- Create foo from the remote table foo on the server bar > CREATE FOREIGN TABLE foo SERVER bar; > -- Create zero-column table foo > CREATE FOREIGN TABLE foo () SERVER bar; That syntax seems pretty obvious. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
