I'm using the PgDump component to dump several tables to a file. But if I select the tables with the property TableNames no tables are dumped at all.
example code I'm using
dumpquery.TableNames := 'Table1,Table2';
I don't get the dump of the actual tables.
Thx for help
PgDump problem
-
- Devart Team
- Posts: 271
- Joined: Wed 23 Jan 2013 11:21
Re: PgDump problem
Hello.
In order to store the table data when backing up, the TPgDump.Mode property must be set to dmData or dmAll, and the doTables parameter in the TPgDump.ObjectTypes options must be set to True. Please make sure the specified options and property are set properly.
You can find the detailed information about TPgDump.Mode and TPgDump.ObjectTypes in the PgDAC documentation.
In order to store the table data when backing up, the TPgDump.Mode property must be set to dmData or dmAll, and the doTables parameter in the TPgDump.ObjectTypes options must be set to True. Please make sure the specified options and property are set properly.
You can find the detailed information about TPgDump.Mode and TPgDump.ObjectTypes in the PgDAC documentation.
Re: PgDump problem
Hello.
I'm using the PgDump component to dump several tables to a file too using default setting for the PgDump component (especially Options.AddDrop := True)
but in the resulting file I don't see any DROP commands.. for tables, sequences, indexes, etc.
Why?
p.s.
-- PgDAC version: 4.0.2
-- PostgreSQL server version: 8.4.17
-- PostgreSQL client version: Direct
I'm using the PgDump component to dump several tables to a file too using default setting for the PgDump component (especially Options.AddDrop := True)
but in the resulting file I don't see any DROP commands.. for tables, sequences, indexes, etc.
Why?
p.s.
-- PgDAC version: 4.0.2
-- PostgreSQL server version: 8.4.17
-- PostgreSQL client version: Direct
-
- Devart Team
- Posts: 271
- Joined: Wed 23 Jan 2013 11:21
Re: PgDump problem
Hello.
The AddDrop option is responsible for deleting data in tables. For the time being, on forming backup, TPgDump doesn't add instructions for deleting database objects. We will consider the possibility to add this functionality in future.
The AddDrop option is responsible for deleting data in tables. For the time being, on forming backup, TPgDump doesn't add instructions for deleting database objects. We will consider the possibility to add this functionality in future.
Re: PgDump problem
Hi,
nothing has changed over the years for PgDump.pas
In each version PgDAC I have to add my code in PgDump.pas
For example, my latest version 7.1.1 is here
https://disk.yandex.ru/d/THAPc5_wBgHdvA
nothing has changed over the years for PgDump.pas
In each version PgDAC I have to add my code in PgDump.pas
For example, my latest version 7.1.1 is here
https://disk.yandex.ru/d/THAPc5_wBgHdvA
Re: PgDump problem
Hi there,
We are working on this functionality extension.
An option to delete objects before creation will be added in the nearest release.
We are working on this functionality extension.
An option to delete objects before creation will be added in the nearest release.