From: | Erik Darling <edarling80(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Dynamic SQL - transition from ms to pg |
Date: | 2014-01-06 05:13:28 |
Message-ID: | CAO+EYwKZ9DUn_NUzwVL5mGMV7NKHKQbVakuAuUsKcYiHLRjGMA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I've been developing for MS SQL around four years. I'm starting out with
some work in Postgresql next week, and I'd like to know if there's any
equivalent way to do something like this (from my word press)
http://sqldriver.wordpress.com/2013/12/09/generating-inserts-dynamically/
My question is mainly about creating comma delimited column names as
variables and executing dynamic SQL with them. I've spent some time trying
to find an answer and I seem to keep running into the same few stack
questions.
Any advice is appreciated. I think I'm going to end up needing dynamic
queries like what I've written for similar tasks moving data from files to
staging tables and then to a larger set of data warehouse tables and
setting up either views (perhaps materialized?) or more tables for
reporting.
Thanks,
Erik
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2014-01-06 06:18:42 | Re: Dynamic SQL - transition from ms to pg |
Previous Message | Keith Fiske | 2014-01-06 04:56:08 | Re: Planning error in dynamic string creation in plpgsql |