Re: Use Dblink without column defination

Hi Team, Any update on this? Thank You. Regards, Chirag Karkera On Mon, 23 May, 2022, 1:46 pm Chirag Karkera, wrote: > Hi Team, > > Appreciate your time to look into this. > > To select from another database I try to use dblink or fdw extension of > Postgres, like this: &

Use Dblink without column defination

This works fine when I specify which columns I want to select. Is there something that postgres has without specifying the column names we can fetch the data from dblink. Awaiting your reply. Thank you. Regards, Chirag Karkera

Re: Provide read-only access to system catalog tables

Thank you for the clarification. Will use the system catalogs tables. Thank You. Regards, Chirag Karkera On Tue, May 17, 2022 at 6:59 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Tue, May 17, 2022 at 6:21 AM Chirag Karkera > wrote: > >> Thanks

Re: Provide read-only access to system catalog tables

Thanks David for your reply! But when i created a role i am not able to view objects under information_schema.* I mean I am not able to view the data, I can see only the column names. Thanks. Regards, Chirag Karkera On Tue, May 17, 2022 at 6:40 PM David G. Johnston < david.g.jo

Provide read-only access to system catalog tables

(information_schema and pg_catalog) I have surfed a lot of materials online, but did not get any solution for the same. Request you to share some valuable input on this. Thank You. Regards, Chirag Karkera