question

UdayKiranReddyureddy-2664 avatar image
0 Votes"
UdayKiranReddyureddy-2664 asked OuryBa-MSFT answered

How to create table in postgres from template?

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-database-postgresqlazure-dtl-arm-enviorments
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

OuryBa-MSFT avatar image
0 Votes"
OuryBa-MSFT answered

Hi @UdayKiranReddyureddy-2664 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

5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.