Product: Aqua Data Studio

Version: 16.0.1-8

Build #: 43117

Build Date: 2015-Mar-24 04:04:04 PM

 

Operating Environment: Linux (3.13.0-32-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.7.0_60-b19

Memory: Max=704,643,072; Total=320,339,968; Free=222,389,520; CPUs=8

 

Steps to reproduce:

1. Connect to PostgreSQL 9.3.

2. Create a table in 'public' schema:

 

CREATE TABLE public.bit_string_datatype (

bit_col bit(1) NULL

)

GO

 

3. Insert values in it.

 

INSERT INTO public.bit_string_datatype(bit_col)

VALUES('1')

GO

 

INSERT INTO public.bit_string_datatype(bit_col)

VALUES('0')

GO

 

4. Run SELECT* query on it.

 

SELECT * FROM public.bit_string_datatype

GO

5. For bit datatype data displayed successfully in Grid tab.

6. Now Right click on Table 'bit_string_datatype' and Select option 'Tools -> Export Data' to Export data of this to any .csv (say bit.csv) file.

 

7. In Export Data window->Status Tab, it displays message Data Exported successfully.

 

But when we open file (bit.csv) in which we have exported data, no data is displayed in it.

Unable to export data of bit datatype.