Skip to content

ALTER EXTERNAL FORMAT

Alter an external format object.

ALTER EXTERNAL FORMAT name
TYPE file_type
WITH (option value [,option value] ...)

For details about TYPE and WITH options, see CREATE EXTERNAL FORMAT.

For example:

premdb=# alter external format premdbs3format type text with(nullmarker 'NULL');
ALTER EXTERNAL FORMAT

You must have the correct privileges to run this command. See ON EXTERNAL object.