Navicat's Data Transfer feature allows you to transfer tables/records from one PostgreSQL database to another PostgreSQL database or a plain text file. The target database can be on the same server as the source database or on another PostgreSQL server. Navicat allows you to save a profile for easy retrieval and running of Data Transfer between databases.

1. On the Tools Menu, click Data Transfer
   
2. Go to the General Settings tab, enter the source server and target server settings
   
3. Go to the Advanced Settings tab and enter the settings
   
4. Click the Save button to save your settings
   
   

Deleting a Data Transfer profile

1. On the Tools Menu, click Data Transfer
   
2. Select the profile you want to delete from the Load Profile
   
3. Click Delete Button

Setting up the General Settings

1. Select Source Connection.
   
2. Select Source Database and then the tables.
   
3. To Transfer to another PostgreSQL database, check Transfer directly to server. Select the Target Connection and Database.
   
4. To Transfer to plain text file, check Transfer to file. Select the file in the edit box.

Setting up the Advanced Settings

1. In the Table Options, select whether to create tables in the target database.
   
2. Select whether a table must be dropped before it is created
   
3. In the Record Options, select whether to create the records in the target database
   
4. Indicate whether Navicat must use complete insert statements when posting the records to the target database
   
5. Indicate whether to lock the target tables before inserting new records