Devart Forums

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

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.

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

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.

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

Hi there,
We are working on this functionality extension.
An option to delete objects before creation will be added in the nearest release.