Re: [ADMIN] Import & Export DB table structure with data

Поиск
Список
Период
Сортировка
От Ashwani Kumar B
Тема Re: [ADMIN] Import & Export DB table structure with data
Дата
Msg-id AM3PR07MB35496BAFF8327FF79304F96C0A60@AM3PR07MB354.eurprd07.prod.outlook.com
обсуждение исходный текст
Ответ на Re: [ADMIN] Import & Export DB table structure with data  (Om Prakash Jaiswal <op12om@yahoo.co.in>)
Список pgsql-admin
Дерево обсуждения

How do I get table structure query so that I can create the same on other DB

 

From: Om Prakash Jaiswal [mailto:op12om@yahoo.co.in]
Sent: Wednesday, July 19, 2017 11:38 AM
To: Ashwani Kumar B; pgsql-performance-owner@postgresql.org; pgsql-sql-owner@postgresql.org; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Import & Export DB table structure with data

 

Dear Aswin,

you have to create table at receiving end and use dblink() function of postgresql.

 

Regards

Om Prakash

 

 

On Wednesday, 19 July 2017 11:27 AM, Ashwani Kumar B <ashwani.b.kumar@ericsson.com> wrote:

 

Hi

 

I have to import table structure from one DB  and create the same table structure in another DB.

 

Secondly I have to copy all the data from one DB to another DB

 

Kindly suggest way forward.

 

Regards

Ashwani

 

В списке pgsql-admin по дате отправления:

Предыдущее
От: Om Prakash Jaiswal
Дата:
Сообщение: Re: [ADMIN] Import & Export DB table structure with data
Следующее
От: vinny
Дата:
Сообщение: Re: [ADMIN] Import & Export DB table structure with data