Substitute for table variable and data migration approach

From: Avadhut Narayan Joshi <AJoshi7(at)sensiaglobal(dot)com>
To: "pgsql-sql(at)lists(dot)postgresql(dot)org" <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: Substitute for table variable and data migration approach
Date: 2021-07-05 11:05:01
Message-ID: PH0PR18MB46083689E7220C17D80C00229C1C9@PH0PR18MB4608.namprd18.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello Geeks ,

As in SQL Server we have table variable and it can be passed as a parameter to a stored procedure . Which is the best alternative for it in PostgreSQL ?

Also any advice / suggestions on tool which can be used to migrate data from SQL Server / Oracle to PostgreSQL ?
Solution should be

1. Performant on large DB size > 500 GB
2. Should have re-start logic
3. Should have error logging capabilities
4. Easy to deploy/use in Prod environment

Please give Suggestions / recommendations .

Regards
Avadhut

Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Steve Midgley 2021-07-06 15:23:46 Re: Substitute for table variable and data migration approach
Previous Message Дмитрий Иванов 2021-07-02 15:30:57 Re: LAST_VALUE returns the entire partition