How to create PostgreSQL project in Visual Studio 2019?

Question

How to create a PostgreSQL database project in Visual Studio 2019 as like we are doing SQL DB Project????.

Visual Studio has provided SQL Database project template but I didn't find anything for PostgreSQL Database.

We are using AzureDevops + GITHUB for repositories. So need to create one repo for PostgreSQL schemas Also need to create postgreSQL database through CI/CD (Jenkin tool/AzureDevOps tool)

Need to maintain version control of each database object in the form of SQL script file. So, is there any such provision (may be in the form of plug-in) in Visual Studio 2019 or can we utilize SQL server database project for storing PostgreSQL schemas?

Answer 1

Hello @Vinod Bhoite ,

Welcome to Microsoft Q&A forum.

Visual Studio 2019 doesn’t provide a specific PostgreSQL Database project template, you may need to consider other methods.

Is there any such provision (may be in the form of plug-in) in VS 2019.

Not sure if some extensions may meet your requirements, you can check the extensions from Visual Studio Marketplace.

Best Regards,
Tianyu

• If the answer is helpful, please click "Accept Answer" and upvote it.
  Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.