PostgreSQL

• Topics

  Started by

  Posts

  Last post

• How to add metadata for every record in Azure postgres tables

  Hi, I have a situation in one of the applications I am working on where prior to going live in prod…

  kaleparag

  3 replies

  3 weeks, 4 days ago

  By: Grant Fritchey

• Need query help - MAX record

  I am having trouble writing linking the MAX query that I created back to the table to produce other…

  jmerlau

  2 replies

  1 month, 3 weeks ago

  By: pietlinden

• Need query help - MAX record

  Hello - I have attached a Word document here with details about my issue. I have shown an excerpt f…

  jmerlau

  2 replies

  1 month, 3 weeks ago

  By: pietlinden

• Permission issue in updating cron.job table in postgresql

  I am using postgreSQL database for azure flexible server. I have enabled pg_cron extension on azure…

  Naveen J V

  7 replies

  6 months, 3 weeks ago

  By: Ryan Booz

• Deployment Tool for Postgres SQL Database

  Can someone please recommend a good deployment tool for a Postgres SQL Database We are looking for …

  JimReeves71

  1 replies

  1 year, 4 months ago

  By: Grant Fritchey

• Will the pg_stat_statements view show old data if there is no transaction going?

  Hi, I am trying to write a query using pg_stat_statements to find the elapsed time of queries runni…

  dheepakraj_1716

  2 replies

  1 year, 5 months ago

  By: Grant Fritchey

• PostgreSQL authenticated against Microsoft Active Directory

  Can I authenticate with Active Directory and get into PostgreSQL? Version: PostgreSQL 16.1 on Windo…

  SSRSNoob

  2 replies

  1 year, 6 months ago

  By: Mr. Brian Gale

• TSQL To Postgres - Unpivot/Union All

  I am trying to convert this TSQL:INSERT INTO temp_FieldFlowsFact   SELECT [Account],[Calendar …

  yrstruly

  1 replies

  1 year, 11 months ago

  By: yrstruly

• TSQL To Postgres - Unpivot/Union All

  I am trying to convert this TSQL:INSERT INTO temp_FieldFlowsFact   SELECT [Account],[Calendar …

  yrstruly

  1 replies

  1 year, 11 months ago

  By: ratbak

• Create the AS clause for Postgres crosstab dynamically.

  This is a continuation of Dynamically creating columns for crosstab in PostgreSQL. To be clear, I c…

  Piyushbhatt

  1 replies

  2 years, 5 months ago

  By: Grant Fritchey

• Upgrade from RDS Postgres 11 to 14

  Hi, Would like to know if there are any code changes needed to upgrade RDS postgres 11 to 14.

  amelia.monicad

  2 replies

  2 years, 5 months ago

  By: Grant Fritchey

• newbie db design question

  hello! really noob question here. i have this experimental database design: create table products (…

  rino19ny

  5 replies

  3 years ago

  By: pietlinden

• Turn on Query Execution Time Command

  Hey, I am in the learning state for PostgreSQL and looking to turn on query execution command examp…

  Ankitdixit

  3 replies

  3 years, 1 month ago

  By: Grant Fritchey

• AWS RDS PostgreSQL to MySQL Replication

  Hi, I have a client requirement to replicate data from AWS RDS Postgres DB (Source) to AWS RDS MySQ…

  vamshi.sql

  1 replies

  3 years, 3 months ago

  By: vamshi.sql

• clone table with partial data and all structure

  I'm trying to clone a table in sql with partial data but with all structure (index, etc). This is t…

  vieiralage

  1 replies

  3 years, 6 months ago

  By: Mr. Brian Gale