~ubuntu-branches/debian/sid/postgresql-9.3/sid

[ OPTIONS ( [ ADD | SET | DROP ] <replaceable class="PARAMETER">option</replaceable> ['<replaceable class="PARAMETER">value</replaceable>'] [, ... ]) ]

ALTER FOREIGN DATA WRAPPER <replaceable class="parameter">name</replaceable> OWNER TO <replaceable>new_owner</replaceable>

ALTER FOREIGN DATA WRAPPER <replaceable class="parameter">name</replaceable> RENAME TO <replaceable>new_name</replaceable>

</synopsis>

</refsynopsisdiv>

<title>Description</title>

<para>

<command>ALTER FOREIGN DATA WRAPPER</command> changes the

definition of a foreign-data wrapper. The first form of the

command changes the support functions or the generic options of the

foreign-data wrapper (at least one clause is required). The second

form changes the owner of the foreign-data wrapper.

</para>

<para>

Only superusers can alter foreign-data wrappers. Additionally,

only superusers can own foreign-data wrappers.

</para>

</refsect1>

<title>Parameters</title>

<para>

The name of an existing foreign-data wrapper.

</para>

</listitem>

</varlistentry>

<term><literal>HANDLER <replaceable class="parameter">handler_function</replaceable></literal></term>

<para>

Specifies a new handler function for the foreign-data wrapper.

</para>

</listitem>

</varlistentry>

<term><literal>NO HANDLER</literal></term>

<para>

This is used to specify that the foreign-data wrapper should no

longer have a handler function.

</para>

<para>

Note that foreign tables that use a foreign-data wrapper with no

handler cannot be accessed.

</para>

</listitem>

</varlistentry>

<term><literal>VALIDATOR <replaceable class="parameter">validator_function</replaceable></literal></term>

<para>

Specifies a new validator function for the foreign-data wrapper.

</para>

<para>

Note that it is possible that after changing the validator the

options to the foreign-data wrapper, servers, and user mappings

have become invalid. It is up to the user to make sure that

these options are correct before using the foreign-data

wrapper.

</para>

100

</listitem>

101

</varlistentry>

102

103

104

<term><literal>NO VALIDATOR</literal></term>

105

106

<para>

107

This is used to specify that the foreign-data wrapper should no

108

longer have a validator function.

109

</para>

110

</listitem>

111

</varlistentry>

112

113

114

<term><literal>OPTIONS ( [ ADD | SET | DROP ] <replaceable class="PARAMETER">option</replaceable> ['<replaceable class="PARAMETER">value</replaceable>'] [, ... ] )</literal></term>

115

116

<para>

117

Change options for the foreign-data

118

wrapper. <literal>ADD</>, <literal>SET</>, and <literal>DROP</>

119

specify the action to be performed. <literal>ADD</> is assumed

120

if no operation is explicitly specified. Option names must be

121

unique; names and values are also validated using the foreign

122

data wrapper's validator function, if any.

123

</para>

124

</listitem>

125

</varlistentry>

126

127

128

<term><replaceable class="PARAMETER">new_owner</replaceable></term>

129

130

<para>

131

The user name of the new owner of the foreign-data wrapper.

132

</para>

133

</listitem>

134

</varlistentry>

135

136

137

138

139

<para>

140

The new name for the foreign-data wrapper.

141

</para>

142

</listitem>

143

</varlistentry>

144

</variablelist>

145

</refsect1>

146

147

148

<title>Examples</title>

149

150

<para>

151

Change a foreign-data wrapper <literal>dbi</>, add

152

option <literal>foo</>, drop <literal>bar</>:

153

154

ALTER FOREIGN DATA WRAPPER dbi OPTIONS (ADD foo '1', DROP 'bar');

155

</programlisting>

156

</para>

157

158

<para>

159

Change the foreign-data wrapper <literal>dbi</> validator

160

to <literal>bob.myvalidator</>:

161

162

ALTER FOREIGN DATA WRAPPER dbi VALIDATOR bob.myvalidator;

163

</programlisting></para>

164

</refsect1>

165

166

167

<title>Compatibility</title>

168

169

<para>

170

<command>ALTER FOREIGN DATA WRAPPER</command> conforms to ISO/IEC

171

9075-9 (SQL/MED), except that the <literal>HANDLER</literal>,

172

<literal>VALIDATOR</>, <literal>OWNER TO</>, and <literal>RENAME</literal>

173

clauses are extensions.

174

</para>

175

</refsect1>

176

177

178

179

180

181

182

183

</simplelist>

184

</refsect1>

185

186

</refentry>

Older »