Great tutorial on using postgres_fdw. But I have a question, suppose the table has an 'id' column which is a auto serial. What is the best approach to do an INSERT query into the foreign table for this? I see in your INSERT example on the foreign table that you were explicitly providing the value of 'deptno' field. But let's say 'deptno' is a serial, what is the best way to provide this when we do an INSERT query to the foreign table? I tried doing this but it fails. In my INSERT query, I am skipping the `deptno` field since it's a serial and the value should be provided automatically by nextval function (which is based on the sequence specified). But postgres would return an error saying that the value provided to `'deptno` is NULL. Thanks in advance !
Great tutorial on using postgres_fdw. But I have a question, suppose the table has an 'id' column which is a auto serial. What is the best approach to do an INSERT query into the foreign table for this?
I see in your INSERT example on the foreign table that you were explicitly providing the value of 'deptno' field. But let's say 'deptno' is a serial, what is the best way to provide this when we do an INSERT query to the foreign table?
I tried doing this but it fails. In my INSERT query, I am skipping the `deptno` field since it's a serial and the value should be provided automatically by nextval function (which is based on the sequence specified). But postgres would return an error saying that the value provided to `'deptno` is NULL.
Thanks in advance !
Do Aurora Serverless v2 supports FDW?
is there foreign data wrapper for Postgres to Taradata?
If user wants only select privilege. How to grant In remote machine