Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Michael Pavitsky: "SQL Maestro Group provided the kind of services and support for managing PostgreSQL data expected in a true business partnership. Their devotion to customer satisfaction and cost curtailment is a pleasure for PostgreSQL users. I wouldn?t hesitate to recommend PostgreSQL Data Wizard to any of my peers and I know and trust they will surpass all expectations".
Josh Armstrong: "I absolutely love this software! It will me take our migration time down by an order of magnitude. It has especially helped with my indexing as my database contains many complex ones".

More

Add your opinion

PostgreSQL Data Wizard online Help

Prev Return to chapter overview Next

Setting files for import

To load BLOB files, specify the file name template using filed name tags (i.e. %id%, %user%, where 'id' and 'user' are the fact table columns).

 

Example:

Suppose we have a table 'employee' with Non-Blob data as follows:

Id       User

1        Max

2        July

To import D:\Data\1.jpg and D:\Data\2.jpg to a BLOB column of the table, specify D:\Data as directory name and %Id%.jpg as file name template.

 

 

You can define the default root directory with %root_dir%, %table_name%, and %field_name% tags.

 



Prev Return to chapter overview Next