Azure PostgreSQL is a relational database service for app development and deployment based on the open source Postgres database engine.
Links:
Questions tagged [azure-postgresql]
171 questions
0
votes
1 answer
Design for a Cloud Native Application in Azure for ML Insights and Actions
I have an idea whereby I intend to build a cloud native application for algorithmic trading, ideally by consuming all PaaS and SaaS (no IaaS), and I'd like to get some feedback on how I intend to build it. The concept is pretty straight-forward in…
jbush
- 11
- 6
0
votes
2 answers
Why is this Azure firewall rule required?
I'm hoping someone here might have an idea what's causing this. I've got an AKS cluster with a number of microservices accessing resources in an Azure Postgres database server. I have firewall rules defined for the Postgres server for both the POD…
user3280383
- 465
- 2
- 6
- 17
0
votes
1 answer
Thingworx Platform-settings.json file not connecting to azure Database
I am trying to connect the Thingworx 7.1 to Azure Postgresql database.
I have successfully able to point the the Thingworx Things to azure database without any error.
But when I am trying to set the database url inside the platform-settings file to…
Tarun
- 271
- 1
- 6
- 18
0
votes
1 answer
how to read csv files stored in azure storage account into azure psql
When i run the below code to import data from csv file stored in azure storage account i get following error:
syntax error at or near "CREDENTIALS"
COPY ccsm.vital_signs FROM
'https://abc.blob.core.windows.net/dta/abc.csv'
CREDENTIALS…
Sachin
- 35
- 1
- 1
- 6
0
votes
1 answer
function pg_catalog.btrim(numeric, unknown) does not exist while creating table
psql code:
CREATE TABLE ref_lab_cohort_level
AS
SELECT cohort,initcap (TRIM (result_flag)) AS result_flag,
TRIM (cohort_level) AS cohort_level
FROM temp_labs_levels;
In above code, trim is function of PostgreSQL for trimming but it gives…
Sachin
- 35
- 1
- 1
- 6
-3
votes
1 answer
Getting "syntax error at or near '('" Postgresql
I am new to SQL. I am getting this error and I'm not sure where is the problem:
syntax error at or near "("
This is my SQL query for postgres:
DROP TABLE IF EXISTS posts;
CREATE TABLE posts (
title VARCHAR(10000) NOT NULL,
url…
Dani
- 556
- 7
- 23