PostgreSQL

• Topics

  Started by

  Posts

  Last post

• 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

  3 days, 21 hours 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

  9 months, 3 weeks 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

  10 months, 3 weeks 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 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, 5 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, 5 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

  1 year, 11 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

  1 year, 11 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

  2 years, 6 months 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

  2 years, 6 months 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

  2 years, 8 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

  2 years, 11 months ago

  By: Mr. Brian Gale

• Search ALL tables for a String Value using DBeaver

  Hi Forum, I'm usually a SQL Server coder & I've started using DBeaver to do a value search on a…

  Oscar_Boots

  3 replies

  3 years, 7 months ago

  By: Oscar_Boots

• OLE DB provider "PGNP" for linked server "MyLinkedServer" reported an error

  Hi, I am trying to migrate SQL Server databases from 2008 to 2019.  My old server has a linked ser…

  Roust_m

  1 replies

  4 years ago

  By: Roust_m

• Update a column with max value of multiple columns in another table

  Hi, I have two tables, a simplified schema is like this: Plan (plan_id, modified_time) Plan_review(…

  Roust_m

  2 replies

  4 years, 3 months ago

  By: DesNorton