Share via

How to Create Global temporary tables in Azure Database for PostgreSQL flexible server

Naveen Kumar Kakarla (Quadrant Resource LLC) 125 Reputation points
2023-06-14T12:34:39.2933333+00:00

Hi Team,

Kindly provide us the steps to create Global temporary table for Azure database for PostgreSQL. Currently we are using PostgreSQL 14.7

Azure Database for PostgreSQL
0 comments
Accepted answer
  1. GeethaThatipatri-MSFT 29,547 Reputation points Microsoft Employee Moderator
    2023-06-14T14:42:26.04+00:00

    Hi,@Naveen Kumar Kakarla (Quadrant Resource LLC) Thanks for posting your question in the Microsoft Q&A forum.

    Unfortunately, Global Temporary Tables are not supported in Azure Database for PostgreSQL Flexible Server.

    However, PostgreSQL does support temporary tables, which are similar to Global Temporary Tables in some ways. Temporary tables are created in a similar way to regular tables, but they are automatically dropped at the end of the session or transaction.

    I hope this information helps, please let me know if you need any additional information.

    Regards

    Geetha

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.