Postgres Pro
Downloads
Home   >   mailing lists

Substitute for table variable and data migration approach - Mailing list pgsql-sql

From Avadhut Narayan Joshi
Subject Substitute for table variable and data migration approach
Date
Msg-id PH0PR18MB46083689E7220C17D80C00229C1C9@PH0PR18MB4608.namprd18.prod.outlook.com
Whole thread Raw
Responses Re: Substitute for table variable and data migration approach  (Steve Midgley <science@misuse.org>)
List pgsql-sql
Tree view

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 for Windows 10

 

pgsql-sql by date:

Previous
From: Дмитрий Иванов
Date:
Subject: Re: LAST_VALUE returns the entire partition
Next
From: Steve Midgley
Date:
Subject: Re: Substitute for table variable and data migration approach