Loading Serviceability Extended Attributes Data - serviceability_extended_attributes

Download the product delivery file

Extract the delivery file and find the data text file

Open the SEA Create Table script in a text editor and confirm that the table name is set to serviceability_extended_attributes

Run the Create Table script

After the table structure has been created, copy data using the PostgreSQL Copy command:

copy serviceability_extended_attributes from program 'cmd /c
"type <path of data file>"' with (format csv ,delimiter '	',header true)

If this syntax doens't work, the alternate command shown below can be used:

copy serviceability_extended_attributes from program 'cmd /c
"type <path of data file>"' with (format csv ,delimiter e'\t',header true)

Syntax:

<table_name>: Name of table created using Create Table script

<path_to_text_file>: Path to extracted data text file

<text_file_name.txt>: Extracted data text file name, including file extension

<delimiter>: Defines the text delimiter (in this case, delimiter is tab)

<e'/t'>: Specifies alternate quoting for tab delimiter

Example:

copy serviceability_extended_attributes from program 'cmd /c "type F:\serviceability_extended_attributes\
serviceability_extended_attributes.txt"' with (format csv ,delimiter '    ',header true)

Alternate command:

copy serviceability_extended_attributes from program 'cmd /c "type F:\serviceability_extended_attributes\
serviceability_extended_attributes.txt"' with (format csv ,delimiter e'\t',header true)

Loading Serviceability Extended Attributes Data - serviceability_extended_attributes - Main

Serviceability Extended Attributes Getting Started Guide