Share via

How to create table in postgres from template?

Uday Kiran Reddy (ureddy) 96 Reputation points
2022-03-22T14:37:44.25+00:00

We are creating a postgres flexible server using bicep template.

And we found option to create database as part of it using link

Is there anyway to create a table also as part of template?

Azure DevTest Labs
Azure DevTest Labs
An Azure service that is used for provisioning development and test environments.
279 questions
Azure Database for PostgreSQL
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Oury Ba-MSFT 19,886 Reputation points Microsoft Employee
    2022-03-23T00:22:13.823+00:00

    Hi @Uday Kiran Reddy (ureddy) Thank you for posting your question on Microsoft Q&A and for using Azure services.

    My understanding is that you are able to create an Azure PostgreSQL flexible server using ARM templates but cannot find a way to create tables as part of the template. Please let me know if my understanding is not correct.

    Unfortunately, there is no API to create a table in azure PostgreSQL, not even from the portal. That has to connect to server to do so.

    Regards,
    Oury

    0 comments

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.