~ubuntu-branches/ubuntu/lucid/postgresql-8.4/lucid-proposed

N_("ALTER AGGREGATE name ( type [ , ... ] ) RENAME TO new_name\nALTER AGGREGATE name ( type [ , ... ] ) OWNER TO new_owner\nALTER AGGREGATE name ( type [ , ... ] ) SET SCHEMA new_schema") },

{ "ALTER CONVERSION",

N_("change the definition of a conversion"),

N_("ALTER CONVERSION name RENAME TO newname\nALTER CONVERSION name OWNER TO newowner") },

{ "ALTER DATABASE",

N_("change a database"),

N_("ALTER DATABASE name [ [ WITH ] option [ ... ] ]\n\nwhere option can be:\n\n CONNECTION LIMIT connlimit\n\nALTER DATABASE name RENAME TO newname\n\nALTER DATABASE name OWNER TO new_owner\n\nALTER DATABASE name SET TABLESPACE new_tablespace\n\nALTER DATABASE name SET configuration_parameter { TO | = } { value | DEFAULT }\nALTER DATABASE name SET configuration_parameter FROM CURRENT\nALTER DATABASE name RESET configuration_parameter\nALTER DATABASE name RESET ALL") },

{ "ALTER DOMAIN",

N_("change the definition of a domain"),

N_("ALTER DOMAIN name\n { SET DEFAULT expression | DROP DEFAULT }\nALTER DOMAIN name\n { SET | DROP } NOT NULL\nALTER DOMAIN name\n ADD domain_constraint\nALTER DOMAIN name\n DROP CONSTRAINT constraint_name [ RESTRICT | CASCADE ]\nALTER DOMAIN name\n OWNER TO new_owner \nALTER DOMAIN name\n SET SCHEMA new_schema") },

{ "ALTER FOREIGN DATA WRAPPER",

N_("change the definition of a foreign-data wrapper"),

N_("ALTER FOREIGN DATA WRAPPER name\n [ VALIDATOR valfunction | NO VALIDATOR ]\n [ OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ]) ]\nALTER FOREIGN DATA WRAPPER name OWNER TO new_owner") },

{ "ALTER FUNCTION",

N_("change the definition of a function"),

N_("ALTER FUNCTION name ( [ [ argmode ] [ argname ] argtype [, ...] ] )\n action [ ... ] [ RESTRICT ]\nALTER FUNCTION name ( [ [ argmode ] [ argname ] argtype [, ...] ] )\n RENAME TO new_name\nALTER FUNCTION name ( [ [ argmode ] [ argname ] argtype [, ...] ] )\n OWNER TO new_owner\nALTER FUNCTION name ( [ [ argmode ] [ argname ] argtype [, ...] ] )\n SET SCHEMA new_schema\n\nwhere action is one of:\n\n CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT\n IMMUTABLE | STABLE | VOLATILE\n [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER\n COST execution_cost\n ROWS result_rows\n SET configuration_parameter { TO | = } { value | DEFAULT }\n SET configuration_parameter FROM CURRENT\n RESET configuration_parameter\n RESET ALL") },

{ "ALTER GROUP",

N_("change role name or membership"),

N_("ALTER GROUP groupname ADD USER username [, ... ]\nALTER GROUP groupname DROP USER username [, ... ]\n\nALTER GROUP groupname RENAME TO newname") },

{ "ALTER INDEX",

N_("change the definition of an index"),

N_("ALTER INDEX name RENAME TO new_name\nALTER INDEX name SET TABLESPACE tablespace_name\nALTER INDEX name SET ( storage_parameter = value [, ... ] )\nALTER INDEX name RESET ( storage_parameter [, ... ] )") },

{ "ALTER LANGUAGE",

N_("change the definition of a procedural language"),

N_("ALTER [ PROCEDURAL ] LANGUAGE name RENAME TO newname\nALTER [ PROCEDURAL ] LANGUAGE name OWNER TO new_owner") },

{ "ALTER OPERATOR",

N_("change the definition of an operator"),

N_("ALTER OPERATOR name ( { lefttype | NONE } , { righttype | NONE } ) OWNER TO newowner") },

{ "ALTER OPERATOR CLASS",

N_("change the definition of an operator class"),

N_("ALTER OPERATOR CLASS name USING index_method RENAME TO newname\nALTER OPERATOR CLASS name USING index_method OWNER TO newowner") },

{ "ALTER OPERATOR FAMILY",

N_("change the definition of an operator family"),

N_("ALTER OPERATOR FAMILY name USING index_method ADD\n { OPERATOR strategy_number operator_name ( op_type, op_type )\n | FUNCTION support_number [ ( op_type [ , op_type ] ) ] funcname ( argument_type [, ...] )\n } [, ... ]\nALTER OPERATOR FAMILY name USING index_method DROP\n { OPERATOR strategy_number ( op_type [ , op_type ] )\n | FUNCTION support_number ( op_type [ , op_type ] )\n } [, ... ]\nALTER OPERATOR FAMILY name USING index_method RENAME TO newname\nALTER OPERATOR FAMILY name USING index_method OWNER TO newowner") },

{ "ALTER ROLE",

N_("change a database role"),

N_("ALTER ROLE name [ [ WITH ] option [ ... ] ]\n\nwhere option can be:\n \n SUPERUSER | NOSUPERUSER\n | CREATEDB | NOCREATEDB\n | CREATEROLE | NOCREATEROLE\n | CREATEUSER | NOCREATEUSER\n | INHERIT | NOINHERIT\n | LOGIN | NOLOGIN\n | CONNECTION LIMIT connlimit\n | [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password'\n | VALID UNTIL 'timestamp' \n\nALTER ROLE name RENAME TO newname\n\nALTER ROLE name SET configuration_parameter { TO | = } { value | DEFAULT }\nALTER ROLE name SET configuration_parameter FROM CURRENT\nALTER ROLE name RESET configuration_parameter\nALTER ROLE name RESET ALL") },

{ "ALTER SCHEMA",

N_("change the definition of a schema"),

N_("ALTER SCHEMA name RENAME TO newname\nALTER SCHEMA name OWNER TO newowner") },

{ "ALTER SEQUENCE",

N_("change the definition of a sequence generator"),

N_("ALTER SEQUENCE name [ INCREMENT [ BY ] increment ]\n [ MINVALUE minvalue | NO MINVALUE ] [ MAXVALUE maxvalue | NO MAXVALUE ]\n [ START [ WITH ] start ]\n [ RESTART [ [ WITH ] restart ] ]\n [ CACHE cache ] [ [ NO ] CYCLE ]\n [ OWNED BY { table.column | NONE } ]\nALTER SEQUENCE name OWNER TO new_owner\nALTER SEQUENCE name RENAME TO new_name\nALTER SEQUENCE name SET SCHEMA new_schema") },

{ "ALTER SERVER",

N_("change the definition of a foreign server"),

N_("ALTER SERVER servername [ VERSION 'newversion' ]\n [ OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] ) ]\nALTER SERVER servername OWNER TO new_owner") },

{ "ALTER TABLE",

N_("change the definition of a table"),

N_("ALTER TABLE [ ONLY ] name [ * ]\n action [, ... ]\nALTER TABLE [ ONLY ] name [ * ]\n RENAME [ COLUMN ] column TO new_column\nALTER TABLE name\n RENAME TO new_name\nALTER TABLE name\n SET SCHEMA new_schema\n\nwhere action is one of:\n\n ADD [ COLUMN ] column type [ column_constraint [ ... ] ]\n DROP [ COLUMN ] column [ RESTRICT | CASCADE ]\n ALTER [ COLUMN ] column [ SET DATA ] TYPE type [ USING expression ]\n ALTER [ COLUMN ] column SET DEFAULT expression\n ALTER [ COLUMN ] column DROP DEFAULT\n ALTER [ COLUMN ] column { SET | DROP } NOT NULL\n ALTER [ COLUMN ] column SET STATISTICS integer\n ALTER [ COLUMN ] column SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN }\n ADD table_constraint\n DROP CONSTRAINT constraint_name [ RESTRICT | CASCADE ]\n DISABLE TRIGGER [ trigger_name | ALL | USER ]\n ENABLE TRIGGER [ trigger_name | ALL | USER ]\n ENABLE REPLICA TRIGGER trigger_name\n ENABLE ALWAYS TRIGGER trigger_name\n DISABLE RULE rewrite_rule_name\n ENABLE RULE rewrite_rule_name\n ENABLE REPLICA RULE rewrite_rule_name\n ENABLE ALWAYS RULE rewrite_rule_name\n CLUSTER ON index_name\n SET WITHOUT CLUSTER\n SET WITH OIDS\n SET WITHOUT OIDS\n SET ( storage_parameter = value [, ... ] )\n RESET ( storage_parameter [, ... ] )\n INHERIT parent_table\n NO INHERIT parent_table\n OWNER TO new_owner\n SET TABLESPACE new_tablespace") },

{ "ALTER TABLESPACE",

N_("change the definition of a tablespace"),

N_("ALTER TABLESPACE name RENAME TO newname\nALTER TABLESPACE name OWNER TO newowner") },

100

{ "ALTER TEXT SEARCH CONFIGURATION",

101

N_("change the definition of a text search configuration"),

102

N_("ALTER TEXT SEARCH CONFIGURATION name\n ADD MAPPING FOR token_type [, ... ] WITH dictionary_name [, ... ]\nALTER TEXT SEARCH CONFIGURATION name\n ALTER MAPPING FOR token_type [, ... ] WITH dictionary_name [, ... ]\nALTER TEXT SEARCH CONFIGURATION name\n ALTER MAPPING REPLACE old_dictionary WITH new_dictionary\nALTER TEXT SEARCH CONFIGURATION name\n ALTER MAPPING FOR token_type [, ... ] REPLACE old_dictionary WITH new_dictionary\nALTER TEXT SEARCH CONFIGURATION name\n DROP MAPPING [ IF EXISTS ] FOR token_type [, ... ]\nALTER TEXT SEARCH CONFIGURATION name RENAME TO newname\nALTER TEXT SEARCH CONFIGURATION name OWNER TO newowner") },

103

104

{ "ALTER TEXT SEARCH DICTIONARY",

105

N_("change the definition of a text search dictionary"),

106

N_("ALTER TEXT SEARCH DICTIONARY name (\n option [ = value ] [, ... ]\n)\nALTER TEXT SEARCH DICTIONARY name RENAME TO newname\nALTER TEXT SEARCH DICTIONARY name OWNER TO newowner") },

107

108

{ "ALTER TEXT SEARCH PARSER",

109

N_("change the definition of a text search parser"),

110

N_("ALTER TEXT SEARCH PARSER name RENAME TO newname") },

111

112

{ "ALTER TEXT SEARCH TEMPLATE",

113

N_("change the definition of a text search template"),

114

N_("ALTER TEXT SEARCH TEMPLATE name RENAME TO newname") },

115

116

{ "ALTER TRIGGER",

117

N_("change the definition of a trigger"),

118

N_("ALTER TRIGGER name ON table RENAME TO newname") },

119

120

{ "ALTER TYPE",

121

N_("change the definition of a type"),

122

N_("ALTER TYPE name RENAME TO new_name\nALTER TYPE name OWNER TO new_owner \nALTER TYPE name SET SCHEMA new_schema") },

123

124

{ "ALTER USER",

125

N_("change a database role"),

126

N_("ALTER USER name [ [ WITH ] option [ ... ] ]\n\nwhere option can be:\n \n SUPERUSER | NOSUPERUSER\n | CREATEDB | NOCREATEDB\n | CREATEROLE | NOCREATEROLE\n | CREATEUSER | NOCREATEUSER\n | INHERIT | NOINHERIT\n | LOGIN | NOLOGIN\n | CONNECTION LIMIT connlimit\n | [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password'\n | VALID UNTIL 'timestamp' \n\nALTER USER name RENAME TO newname\n\nALTER USER name SET configuration_parameter { TO | = } { value | DEFAULT }\nALTER USER name SET configuration_parameter FROM CURRENT\nALTER USER name RESET configuration_parameter\nALTER USER name RESET ALL") },

127

128

{ "ALTER USER MAPPING",

129

N_("change the definition of a user mapping"),

130

N_("ALTER USER MAPPING FOR { username | USER | CURRENT_USER | PUBLIC }\n SERVER servername\n OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] )") },

131

132

{ "ALTER VIEW",

133

N_("change the definition of a view"),

134

N_("ALTER VIEW name ALTER [ COLUMN ] column SET DEFAULT expression\nALTER VIEW name ALTER [ COLUMN ] column DROP DEFAULT\nALTER VIEW name OWNER TO new_owner\nALTER VIEW name RENAME TO new_name\nALTER VIEW name SET SCHEMA new_schema") },

135

136

{ "ANALYZE",

137

N_("collect statistics about a database"),

138

N_("ANALYZE [ VERBOSE ] [ table [ ( column [, ...] ) ] ]") },

139

140

{ "BEGIN",

141

N_("start a transaction block"),

142

N_("BEGIN [ WORK | TRANSACTION ] [ transaction_mode [, ...] ]\n\nwhere transaction_mode is one of:\n\n ISOLATION LEVEL { SERIALIZABLE | REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED }\n READ WRITE | READ ONLY") },

143

144

{ "CHECKPOINT",

145

N_("force a transaction log checkpoint"),

146

N_("CHECKPOINT") },

147

148

{ "CLOSE",

149

N_("close a cursor"),

150

N_("CLOSE { name | ALL }") },

151

152

{ "CLUSTER",

153

N_("cluster a table according to an index"),

154

N_("CLUSTER [VERBOSE] tablename [ USING indexname ]\nCLUSTER [VERBOSE]") },

155

156

{ "COMMENT",

157

N_("define or change the comment of an object"),

158

N_("COMMENT ON\n{\n TABLE object_name |\n COLUMN table_name.column_name |\n AGGREGATE agg_name (agg_type [, ...] ) |\n CAST (sourcetype AS targettype) |\n CONSTRAINT constraint_name ON table_name |\n CONVERSION object_name |\n DATABASE object_name |\n DOMAIN object_name |\n FUNCTION func_name ( [ [ argmode ] [ argname ] argtype [, ...] ] ) |\n INDEX object_name |\n LARGE OBJECT large_object_oid |\n OPERATOR op (leftoperand_type, rightoperand_type) |\n OPERATOR CLASS object_name USING index_method |\n OPERATOR FAMILY object_name USING index_method |\n [ PROCEDURAL ] LANGUAGE object_name |\n ROLE object_name |\n RULE rule_name ON table_name |\n SCHEMA object_name |\n SEQUENCE object_name |\n TABLESPACE object_name |\n TEXT SEARCH CONFIGURATION object_name |\n TEXT SEARCH DICTIONARY object_name |\n TEXT SEARCH PARSER object_name |\n TEXT SEARCH TEMPLATE object_name |\n TRIGGER trigger_name ON table_name |\n TYPE object_name |\n VIEW object_name\n} IS 'text'") },

159

160

{ "COMMIT",

161

N_("commit the current transaction"),

162

N_("COMMIT [ WORK | TRANSACTION ]") },

163

164

{ "COMMIT PREPARED",

165

N_("commit a transaction that was earlier prepared for two-phase commit"),

166

N_("COMMIT PREPARED transaction_id") },

167

168

{ "COPY",

169

N_("copy data between a file and a table"),

170

N_("COPY tablename [ ( column [, ...] ) ]\n FROM { 'filename' | STDIN }\n [ [ WITH ] \n [ BINARY ]\n [ OIDS ]\n [ DELIMITER [ AS ] 'delimiter' ]\n [ NULL [ AS ] 'null string' ]\n [ CSV [ HEADER ]\n [ QUOTE [ AS ] 'quote' ] \n [ ESCAPE [ AS ] 'escape' ]\n [ FORCE NOT NULL column [, ...] ]\n\nCOPY { tablename [ ( column [, ...] ) ] | ( query ) }\n TO { 'filename' | STDOUT }\n [ [ WITH ] \n [ BINARY ]\n [ OIDS ]\n [ DELIMITER [ AS ] 'delimiter' ]\n [ NULL [ AS ] 'null string' ]\n [ CSV [ HEADER ]\n [ QUOTE [ AS ] 'quote' ] \n [ ESCAPE [ AS ] 'escape' ]\n [ FORCE QUOTE column [, ...] ]") },

171

172

{ "CREATE AGGREGATE",

173

N_("define a new aggregate function"),

174

N_("CREATE AGGREGATE name ( input_data_type [ , ... ] ) (\n SFUNC = sfunc,\n STYPE = state_data_type\n [ , FINALFUNC = ffunc ]\n [ , INITCOND = initial_condition ]\n [ , SORTOP = sort_operator ]\n)\n\nor the old syntax\n\nCREATE AGGREGATE name (\n BASETYPE = base_type,\n SFUNC = sfunc,\n STYPE = state_data_type\n [ , FINALFUNC = ffunc ]\n [ , INITCOND = initial_condition ]\n [ , SORTOP = sort_operator ]\n)") },

175

176

{ "CREATE CAST",

177

N_("define a new cast"),

178

N_("CREATE CAST (sourcetype AS targettype)\n WITH FUNCTION funcname (argtypes)\n [ AS ASSIGNMENT | AS IMPLICIT ]\n\nCREATE CAST (sourcetype AS targettype)\n WITHOUT FUNCTION\n [ AS ASSIGNMENT | AS IMPLICIT ]\n\nCREATE CAST (sourcetype AS targettype)\n WITH INOUT\n [ AS ASSIGNMENT | AS IMPLICIT ]") },

179

180

{ "CREATE CONSTRAINT TRIGGER",

181

N_("define a new constraint trigger"),

182

N_("CREATE CONSTRAINT TRIGGER name\n AFTER event [ OR ... ]\n ON table_name\n [ FROM referenced_table_name ]\n { NOT DEFERRABLE | [ DEFERRABLE ] { INITIALLY IMMEDIATE | INITIALLY DEFERRED } }\n FOR EACH ROW\n EXECUTE PROCEDURE funcname ( arguments )") },

183

184

{ "CREATE CONVERSION",

185

N_("define a new encoding conversion"),

186

N_("CREATE [ DEFAULT ] CONVERSION name\n FOR source_encoding TO dest_encoding FROM funcname") },

187

188

{ "CREATE DATABASE",

189

N_("create a new database"),

190

N_("CREATE DATABASE name\n [ [ WITH ] [ OWNER [=] dbowner ]\n [ TEMPLATE [=] template ]\n [ ENCODING [=] encoding ]\n [ LC_COLLATE [=] lc_collate ]\n [ LC_CTYPE [=] lc_ctype ]\n [ TABLESPACE [=] tablespace ]\n [ CONNECTION LIMIT [=] connlimit ] ]") },

191

192

{ "CREATE DOMAIN",

193

N_("define a new domain"),

194

N_("CREATE DOMAIN name [ AS ] data_type\n [ DEFAULT expression ]\n [ constraint [ ... ] ]\n\nwhere constraint is:\n\n[ CONSTRAINT constraint_name ]\n{ NOT NULL | NULL | CHECK (expression) }") },

195

196

{ "CREATE FOREIGN DATA WRAPPER",

197

N_("define a new foreign-data wrapper"),

198

N_("CREATE FOREIGN DATA WRAPPER name\n [ VALIDATOR valfunction | NO VALIDATOR ]\n [ OPTIONS ( option 'value' [, ... ] ) ]") },

199

200

{ "CREATE FUNCTION",

201

N_("define a new function"),

202

N_("CREATE [ OR REPLACE ] FUNCTION\n name ( [ [ argmode ] [ argname ] argtype [ { DEFAULT | = } defexpr ] [, ...] ] )\n [ RETURNS rettype\n | RETURNS TABLE ( colname coltype [, ...] ) ]\n { LANGUAGE langname\n | WINDOW\n | IMMUTABLE | STABLE | VOLATILE\n | CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT\n | [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER\n | COST execution_cost\n | ROWS result_rows\n | SET configuration_parameter { TO value | = value | FROM CURRENT }\n | AS 'definition'\n | AS 'obj_file', 'link_symbol'\n } ...\n [ WITH ( attribute [, ...] ) ]") },

203

204

{ "CREATE GROUP",

205

N_("define a new database role"),

206

N_("CREATE GROUP name [ [ WITH ] option [ ... ] ]\n\nwhere option can be:\n \n SUPERUSER | NOSUPERUSER\n | CREATEDB | NOCREATEDB\n | CREATEROLE | NOCREATEROLE\n | CREATEUSER | NOCREATEUSER\n | INHERIT | NOINHERIT\n | LOGIN | NOLOGIN\n | [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password'\n | VALID UNTIL 'timestamp' \n | IN ROLE rolename [, ...]\n | IN GROUP rolename [, ...]\n | ROLE rolename [, ...]\n | ADMIN rolename [, ...]\n | USER rolename [, ...]\n | SYSID uid") },

207

208

{ "CREATE INDEX",

209

N_("define a new index"),

210

N_("CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] name ON table [ USING method ]\n ( { column | ( expression ) } [ opclass ] [ ASC | DESC ] [ NULLS { FIRST | LAST } ] [, ...] )\n [ WITH ( storage_parameter = value [, ... ] ) ]\n [ TABLESPACE tablespace ]\n [ WHERE predicate ]") },

211

212

{ "CREATE LANGUAGE",

213

N_("define a new procedural language"),

214

N_("CREATE [ PROCEDURAL ] LANGUAGE name\nCREATE [ TRUSTED ] [ PROCEDURAL ] LANGUAGE name\n HANDLER call_handler [ VALIDATOR valfunction ]") },

215

216

{ "CREATE OPERATOR",

217

N_("define a new operator"),

218

N_("CREATE OPERATOR name (\n PROCEDURE = funcname\n [, LEFTARG = lefttype ] [, RIGHTARG = righttype ]\n [, COMMUTATOR = com_op ] [, NEGATOR = neg_op ]\n [, RESTRICT = res_proc ] [, JOIN = join_proc ]\n [, HASHES ] [, MERGES ]\n)") },

219

220

{ "CREATE OPERATOR CLASS",

221

N_("define a new operator class"),

222

N_("CREATE OPERATOR CLASS name [ DEFAULT ] FOR TYPE data_type\n USING index_method [ FAMILY family_name ] AS\n { OPERATOR strategy_number operator_name [ ( op_type, op_type ) ]\n | FUNCTION support_number [ ( op_type [ , op_type ] ) ] funcname ( argument_type [, ...] )\n | STORAGE storage_type\n } [, ... ]") },

223

224

{ "CREATE OPERATOR FAMILY",

225

N_("define a new operator family"),

226

N_("CREATE OPERATOR FAMILY name USING index_method") },

227

228

{ "CREATE ROLE",

229

N_("define a new database role"),

230

N_("CREATE ROLE name [ [ WITH ] option [ ... ] ]\n\nwhere option can be:\n \n SUPERUSER | NOSUPERUSER\n | CREATEDB | NOCREATEDB\n | CREATEROLE | NOCREATEROLE\n | CREATEUSER | NOCREATEUSER\n | INHERIT | NOINHERIT\n | LOGIN | NOLOGIN\n | CONNECTION LIMIT connlimit\n | [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password'\n | VALID UNTIL 'timestamp' \n | IN ROLE rolename [, ...]\n | IN GROUP rolename [, ...]\n | ROLE rolename [, ...]\n | ADMIN rolename [, ...]\n | USER rolename [, ...]\n | SYSID uid") },

231

232

{ "CREATE RULE",

233

N_("define a new rewrite rule"),

234

N_("CREATE [ OR REPLACE ] RULE name AS ON event\n TO table [ WHERE condition ]\n DO [ ALSO | INSTEAD ] { NOTHING | command | ( command ; command ... ) }") },

235

236

{ "CREATE SCHEMA",

237

N_("define a new schema"),

238

N_("CREATE SCHEMA schemaname [ AUTHORIZATION username ] [ schema_element [ ... ] ]\nCREATE SCHEMA AUTHORIZATION username [ schema_element [ ... ] ]") },

239

240

{ "CREATE SEQUENCE",

241

N_("define a new sequence generator"),

242

N_("CREATE [ TEMPORARY | TEMP ] SEQUENCE name [ INCREMENT [ BY ] increment ]\n [ MINVALUE minvalue | NO MINVALUE ] [ MAXVALUE maxvalue | NO MAXVALUE ]\n [ START [ WITH ] start ] [ CACHE cache ] [ [ NO ] CYCLE ]\n [ OWNED BY { table.column | NONE } ]") },

243

244

{ "CREATE SERVER",

245

N_("define a new foreign server"),

246

N_("CREATE SERVER servername [ TYPE 'servertype' ] [ VERSION 'serverversion' ]\n FOREIGN DATA WRAPPER fdwname\n [ OPTIONS ( option 'value' [, ... ] ) ]") },

247

248

{ "CREATE TABLE",

249

N_("define a new table"),

250

N_("CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name ( [\n { column_name data_type [ DEFAULT default_expr ] [ column_constraint [ ... ] ]\n | table_constraint\n | LIKE parent_table [ { INCLUDING | EXCLUDING } { DEFAULTS | CONSTRAINTS | INDEXES } ] ... }\n [, ... ]\n] )\n[ INHERITS ( parent_table [, ... ] ) ]\n[ WITH ( storage_parameter [= value] [, ... ] ) | WITH OIDS | WITHOUT OIDS ]\n[ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ]\n[ TABLESPACE tablespace ]\n\nwhere column_constraint is:\n\n[ CONSTRAINT constraint_name ]\n{ NOT NULL | \n NULL | \n UNIQUE index_parameters |\n PRIMARY KEY index_parameters |\n CHECK ( expression ) |\n REFERENCES reftable [ ( refcolumn ) ] [ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ]\n [ ON DELETE action ] [ ON UPDATE action ] }\n[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]\n\nand table_constraint is:\n\n[ CONSTRAINT constraint_name ]\n{ UNIQUE ( column_name [, ... ] ) index_parameters |\n PRIMARY KEY ( column_name [, ... ] ) index_parameters |\n CHECK ( expression ) |\n FOREIGN KEY ( column_name [, ... ] ) REFERENCES reftable [ ( refcolumn [, ... ] ) ]\n [ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ] [ ON DELETE action ] [ ON UPDATE action ] }\n[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]\n\nindex_parameters in UNIQUE and PRIMARY KEY constraints are:\n\n[ WITH ( storage_parameter [= value] [, ... ] ) ]\n[ USING INDEX TABLESPACE tablespace ]") },

251

252

{ "CREATE TABLE AS",

253

N_("define a new table from the results of a query"),

254

N_("CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name\n [ (column_name [, ...] ) ]\n [ WITH ( storage_parameter [= value] [, ... ] ) | WITH OIDS | WITHOUT OIDS ]\n [ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ]\n [ TABLESPACE tablespace ]\n AS query\n [ WITH [ NO ] DATA ]") },

255

256

{ "CREATE TABLESPACE",

257

N_("define a new tablespace"),

258

N_("CREATE TABLESPACE tablespacename [ OWNER username ] LOCATION 'directory'") },

259

260

{ "CREATE TEXT SEARCH CONFIGURATION",

261

N_("define a new text search configuration"),

262

N_("CREATE TEXT SEARCH CONFIGURATION name (\n PARSER = parser_name |\n COPY = source_config\n)") },

263

264

{ "CREATE TEXT SEARCH DICTIONARY",

265

N_("define a new text search dictionary"),

266

N_("CREATE TEXT SEARCH DICTIONARY name (\n TEMPLATE = template\n [, option = value [, ... ]]\n)") },

267

268

{ "CREATE TEXT SEARCH PARSER",

269

N_("define a new text search parser"),

270

N_("CREATE TEXT SEARCH PARSER name (\n START = start_function ,\n GETTOKEN = gettoken_function ,\n END = end_function ,\n LEXTYPES = lextypes_function\n [, HEADLINE = headline_function ]\n)") },

271

272

{ "CREATE TEXT SEARCH TEMPLATE",

273

N_("define a new text search template"),

274

N_("CREATE TEXT SEARCH TEMPLATE name (\n [ INIT = init_function , ]\n LEXIZE = lexize_function\n)") },

275

276

{ "CREATE TRIGGER",

277

N_("define a new trigger"),

278

N_("CREATE TRIGGER name { BEFORE | AFTER } { event [ OR ... ] }\n ON table [ FOR [ EACH ] { ROW | STATEMENT } ]\n EXECUTE PROCEDURE funcname ( arguments )") },

279

280

{ "CREATE TYPE",

281

N_("define a new data type"),

282

N_("CREATE TYPE name AS\n ( attribute_name data_type [, ... ] )\n\nCREATE TYPE name AS ENUM\n ( 'label' [, ... ] )\n\nCREATE TYPE name (\n INPUT = input_function,\n OUTPUT = output_function\n [ , RECEIVE = receive_function ]\n [ , SEND = send_function ]\n [ , TYPMOD_IN = type_modifier_input_function ]\n [ , TYPMOD_OUT = type_modifier_output_function ]\n [ , ANALYZE = analyze_function ]\n [ , INTERNALLENGTH = { internallength | VARIABLE } ]\n [ , PASSEDBYVALUE ]\n [ , ALIGNMENT = alignment ]\n [ , STORAGE = storage ]\n [ , LIKE = like_type ]\n [ , CATEGORY = category ]\n [ , PREFERRED = preferred ]\n [ , DEFAULT = default ]\n [ , ELEMENT = element ]\n [ , DELIMITER = delimiter ]\n)\n\nCREATE TYPE name") },

283

284

{ "CREATE USER",

285

N_("define a new database role"),

286

N_("CREATE USER name [ [ WITH ] option [ ... ] ]\n\nwhere option can be:\n \n SUPERUSER | NOSUPERUSER\n | CREATEDB | NOCREATEDB\n | CREATEROLE | NOCREATEROLE\n | CREATEUSER | NOCREATEUSER\n | INHERIT | NOINHERIT\n | LOGIN | NOLOGIN\n | CONNECTION LIMIT connlimit\n | [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password'\n | VALID UNTIL 'timestamp' \n | IN ROLE rolename [, ...]\n | IN GROUP rolename [, ...]\n | ROLE rolename [, ...]\n | ADMIN rolename [, ...]\n | USER rolename [, ...]\n | SYSID uid") },

287

288

{ "CREATE USER MAPPING",

289

N_("define a new mapping of a user to a foreign server"),

290

N_("CREATE USER MAPPING FOR { username | USER | CURRENT_USER | PUBLIC }\n SERVER servername\n [ OPTIONS ( option 'value' [ , ... ] ) ]") },

291

292

{ "CREATE VIEW",

293

N_("define a new view"),

294

N_("CREATE [ OR REPLACE ] [ TEMP | TEMPORARY ] VIEW name [ ( column_name [, ...] ) ]\n AS query") },

295

296

{ "DEALLOCATE",

297

N_("deallocate a prepared statement"),

298

N_("DEALLOCATE [ PREPARE ] { name | ALL }") },

299

300

{ "DECLARE",

301

N_("define a cursor"),

302

N_("DECLARE name [ BINARY ] [ INSENSITIVE ] [ [ NO ] SCROLL ]\n CURSOR [ { WITH | WITHOUT } HOLD ] FOR query") },

303

304

{ "DELETE",

305

N_("delete rows of a table"),

306

N_("DELETE FROM [ ONLY ] table [ [ AS ] alias ]\n [ USING usinglist ]\n [ WHERE condition | WHERE CURRENT OF cursor_name ]\n [ RETURNING * | output_expression [ [ AS ] output_name ] [, ...] ]") },

307

308

{ "DISCARD",

309

N_("discard session state"),

310

N_("DISCARD { ALL | PLANS | TEMPORARY | TEMP }") },

311

312

{ "DROP AGGREGATE",

313

N_("remove an aggregate function"),

314

N_("DROP AGGREGATE [ IF EXISTS ] name ( type [ , ... ] ) [ CASCADE | RESTRICT ]") },

315

316

{ "DROP CAST",

317

N_("remove a cast"),

318

N_("DROP CAST [ IF EXISTS ] (sourcetype AS targettype) [ CASCADE | RESTRICT ]") },

319

320

{ "DROP CONVERSION",

321

N_("remove a conversion"),

322

N_("DROP CONVERSION [ IF EXISTS ] name [ CASCADE | RESTRICT ]") },

323

324

{ "DROP DATABASE",

325

N_("remove a database"),

326

N_("DROP DATABASE [ IF EXISTS ] name") },

327

328

{ "DROP DOMAIN",

329

N_("remove a domain"),

330

N_("DROP DOMAIN [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]") },

331

332

{ "DROP FOREIGN DATA WRAPPER",

333

N_("remove a foreign-data wrapper"),

334

N_("DROP FOREIGN DATA WRAPPER [ IF EXISTS ] name [ CASCADE | RESTRICT ]") },

335

336

{ "DROP FUNCTION",

337

N_("remove a function"),

338

N_("DROP FUNCTION [ IF EXISTS ] name ( [ [ argmode ] [ argname ] argtype [, ...] ] )\n [ CASCADE | RESTRICT ]") },

339

340

{ "DROP GROUP",

341

N_("remove a database role"),

342

N_("DROP GROUP [ IF EXISTS ] name [, ...]") },

343

344

{ "DROP INDEX",

345

N_("remove an index"),

346

N_("DROP INDEX [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]") },

347

348

{ "DROP LANGUAGE",

349

N_("remove a procedural language"),

350

N_("DROP [ PROCEDURAL ] LANGUAGE [ IF EXISTS ] name [ CASCADE | RESTRICT ]") },

351

352

{ "DROP OPERATOR",

353

N_("remove an operator"),

354

N_("DROP OPERATOR [ IF EXISTS ] name ( { lefttype | NONE } , { righttype | NONE } ) [ CASCADE | RESTRICT ]") },

355

356

{ "DROP OPERATOR CLASS",

357

N_("remove an operator class"),

358

N_("DROP OPERATOR CLASS [ IF EXISTS ] name USING index_method [ CASCADE | RESTRICT ]") },

359

360

{ "DROP OPERATOR FAMILY",

361

N_("remove an operator family"),

362

N_("DROP OPERATOR FAMILY [ IF EXISTS ] name USING index_method [ CASCADE | RESTRICT ]") },

363

364

{ "DROP OWNED",

365

N_("remove database objects owned by a database role"),

366

N_("DROP OWNED BY name [, ...] [ CASCADE | RESTRICT ]") },

367

368

{ "DROP ROLE",

369

N_("remove a database role"),

370

N_("DROP ROLE [ IF EXISTS ] name [, ...]") },

371

372

{ "DROP RULE",

373

N_("remove a rewrite rule"),

374

N_("DROP RULE [ IF EXISTS ] name ON relation [ CASCADE | RESTRICT ]") },

375

376

{ "DROP SCHEMA",

377

N_("remove a schema"),

378

N_("DROP SCHEMA [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]") },

379

380

{ "DROP SEQUENCE",

381

N_("remove a sequence"),

382

N_("DROP SEQUENCE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]") },

383

384

{ "DROP SERVER",

385

N_("remove a foreign server descriptor"),

386

N_("DROP SERVER [ IF EXISTS ] servername [ CASCADE | RESTRICT ]") },

387

388

{ "DROP TABLE",

389

N_("remove a table"),

390

N_("DROP TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]") },

391

392

{ "DROP TABLESPACE",

393

N_("remove a tablespace"),

394

N_("DROP TABLESPACE [ IF EXISTS ] tablespacename") },

395

396

{ "DROP TEXT SEARCH CONFIGURATION",

397

N_("remove a text search configuration"),

398

N_("DROP TEXT SEARCH CONFIGURATION [ IF EXISTS ] name [ CASCADE | RESTRICT ]") },

399

400

{ "DROP TEXT SEARCH DICTIONARY",

401

N_("remove a text search dictionary"),

402

N_("DROP TEXT SEARCH DICTIONARY [ IF EXISTS ] name [ CASCADE | RESTRICT ]") },

403

404

{ "DROP TEXT SEARCH PARSER",

405

N_("remove a text search parser"),

406

N_("DROP TEXT SEARCH PARSER [ IF EXISTS ] name [ CASCADE | RESTRICT ]") },

407

408

{ "DROP TEXT SEARCH TEMPLATE",

409

N_("remove a text search template"),

410

N_("DROP TEXT SEARCH TEMPLATE [ IF EXISTS ] name [ CASCADE | RESTRICT ]") },

411

412

{ "DROP TRIGGER",

413

N_("remove a trigger"),

414

N_("DROP TRIGGER [ IF EXISTS ] name ON table [ CASCADE | RESTRICT ]") },

415

416

{ "DROP TYPE",

417

N_("remove a data type"),

418

N_("DROP TYPE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]") },

419

420

{ "DROP USER",

421

N_("remove a database role"),

422

N_("DROP USER [ IF EXISTS ] name [, ...]") },

423

424

{ "DROP USER MAPPING",

425

N_("remove a user mapping for a foreign server"),

426

N_("DROP USER MAPPING [ IF EXISTS ] FOR { username | USER | CURRENT_USER | PUBLIC } SERVER servername") },

427

428

{ "DROP VIEW",

429

N_("remove a view"),

430

N_("DROP VIEW [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]") },

431

432

{ "END",

433

N_("commit the current transaction"),

434

N_("END [ WORK | TRANSACTION ]") },

435

436

{ "EXECUTE",

437

N_("execute a prepared statement"),

438

N_("EXECUTE name [ ( parameter [, ...] ) ]") },

439

440

{ "EXPLAIN",

441

N_("show the execution plan of a statement"),

442

N_("EXPLAIN [ ANALYZE ] [ VERBOSE ] statement") },

443

444

{ "FETCH",

445

N_("retrieve rows from a query using a cursor"),

446

N_("FETCH [ direction { FROM | IN } ] cursorname\n\nwhere direction can be empty or one of:\n\n NEXT\n PRIOR\n FIRST\n LAST\n ABSOLUTE count\n RELATIVE count\n count\n ALL\n FORWARD\n FORWARD count\n FORWARD ALL\n BACKWARD\n BACKWARD count\n BACKWARD ALL") },

447

448

{ "GRANT",

449

N_("define access privileges"),

450

N_("GRANT { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER }\n [,...] | ALL [ PRIVILEGES ] }\n ON [ TABLE ] tablename [, ...]\n TO { [ GROUP ] rolename | PUBLIC } [, ...] [ WITH GRANT OPTION ]\n\nGRANT { { SELECT | INSERT | UPDATE | REFERENCES } ( column [, ...] )\n [,...] | ALL [ PRIVILEGES ] ( column [, ...] ) }\n ON [ TABLE ] tablename [, ...]\n TO { [ GROUP ] rolename | PUBLIC } [, ...] [ WITH GRANT OPTION ]\n\nGRANT { { USAGE | SELECT | UPDATE }\n [,...] | ALL [ PRIVILEGES ] }\n ON SEQUENCE sequencename [, ...]\n TO { [ GROUP ] rolename | PUBLIC } [, ...] [ WITH GRANT OPTION ]\n\nGRANT { { CREATE | CONNECT | TEMPORARY | TEMP } [,...] | ALL [ PRIVILEGES ] }\n ON DATABASE dbname [, ...]\n TO { [ GROUP ] rolename | PUBLIC } [, ...] [ WITH GRANT OPTION ]\n\nGRANT { USAGE | ALL [ PRIVILEGES ] }\n ON FOREIGN DATA WRAPPER fdwname [, ...]\n TO { [ GROUP ] rolename | PUBLIC } [, ...] [ WITH GRANT OPTION ]\n\nGRANT { USAGE | ALL [ PRIVILEGES ] }\n ON FOREIGN SERVER servername [, ...]\n TO { [ GROUP ] rolename | PUBLIC } [, ...] [ WITH GRANT OPTION ]\n\nGRANT { EXECUTE | ALL [ PRIVILEGES ] }\n ON FUNCTION funcname ( [ [ argmode ] [ argname ] argtype [, ...] ] ) [, ...]\n TO { [ GROUP ] rolename | PUBLIC } [, ...] [ WITH GRANT OPTION ]\n\nGRANT { USAGE | ALL [ PRIVILEGES ] }\n ON LANGUAGE langname [, ...]\n TO { [ GROUP ] rolename | PUBLIC } [, ...] [ WITH GRANT OPTION ]\n\nGRANT { { CREATE | USAGE } [,...] | ALL [ PRIVILEGES ] }\n ON SCHEMA schemaname [, ...]\n TO { [ GROUP ] rolename | PUBLIC } [, ...] [ WITH GRANT OPTION ]\n\nGRANT { CREATE | ALL [ PRIVILEGES ] }\n ON TABLESPACE tablespacename [, ...]\n TO { [ GROUP ] rolename | PUBLIC } [, ...] [ WITH GRANT OPTION ]\n\nGRANT role [, ...] TO rolename [, ...] [ WITH ADMIN OPTION ]") },

451

452

{ "INSERT",

453

N_("create new rows in a table"),

454

N_("INSERT INTO table [ ( column [, ...] ) ]\n { DEFAULT VALUES | VALUES ( { expression | DEFAULT } [, ...] ) [, ...] | query }\n [ RETURNING * | output_expression [ [ AS ] output_name ] [, ...] ]") },

455

456

{ "LISTEN",

457

N_("listen for a notification"),

458

N_("LISTEN name") },

459

460

{ "LOAD",

461

N_("load or reload a shared library file"),

462

N_("LOAD 'filename'") },

463

464

{ "LOCK",

465

N_("lock a table"),

466

N_("LOCK [ TABLE ] [ ONLY ] name [, ...] [ IN lockmode MODE ] [ NOWAIT ]\n\nwhere lockmode is one of:\n\n ACCESS SHARE | ROW SHARE | ROW EXCLUSIVE | SHARE UPDATE EXCLUSIVE\n | SHARE | SHARE ROW EXCLUSIVE | EXCLUSIVE | ACCESS EXCLUSIVE") },

467

468

{ "MOVE",

469

N_("position a cursor"),

470

N_("MOVE [ direction { FROM | IN } ] cursorname") },

471

472

{ "NOTIFY",

473

N_("generate a notification"),

474

N_("NOTIFY name") },

475

476

{ "PREPARE",

477

N_("prepare a statement for execution"),

478

N_("PREPARE name [ ( datatype [, ...] ) ] AS statement") },

479

480

{ "PREPARE TRANSACTION",

481

N_("prepare the current transaction for two-phase commit"),

482

N_("PREPARE TRANSACTION transaction_id") },

483

484

{ "REASSIGN OWNED",

485

N_("change the ownership of database objects owned by a database role"),

486

N_("REASSIGN OWNED BY old_role [, ...] TO new_role") },

487

488

{ "REINDEX",

489

N_("rebuild indexes"),

490

N_("REINDEX { INDEX | TABLE | DATABASE | SYSTEM } name [ FORCE ]") },

491

492

{ "RELEASE SAVEPOINT",

493

N_("destroy a previously defined savepoint"),

494

N_("RELEASE [ SAVEPOINT ] savepoint_name") },

495

496

{ "RESET",

497

N_("restore the value of a run-time parameter to the default value"),

498

N_("RESET configuration_parameter\nRESET ALL") },

499

500

{ "REVOKE",

501

N_("remove access privileges"),

502

N_("REVOKE [ GRANT OPTION FOR ]\n { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER }\n [,...] | ALL [ PRIVILEGES ] }\n ON [ TABLE ] tablename [, ...]\n FROM { [ GROUP ] rolename | PUBLIC } [, ...]\n [ CASCADE | RESTRICT ]\n\nREVOKE [ GRANT OPTION FOR ]\n { { SELECT | INSERT | UPDATE | REFERENCES } ( column [, ...] )\n [,...] | ALL [ PRIVILEGES ] ( column [, ...] ) }\n ON [ TABLE ] tablename [, ...]\n FROM { [ GROUP ] rolename | PUBLIC } [, ...]\n [ CASCADE | RESTRICT ]\n\nREVOKE [ GRANT OPTION FOR ]\n { { USAGE | SELECT | UPDATE }\n [,...] | ALL [ PRIVILEGES ] }\n ON SEQUENCE sequencename [, ...]\n FROM { [ GROUP ] rolename | PUBLIC } [, ...]\n [ CASCADE | RESTRICT ]\n\nREVOKE [ GRANT OPTION FOR ]\n { { CREATE | CONNECT | TEMPORARY | TEMP } [,...] | ALL [ PRIVILEGES ] }\n ON DATABASE dbname [, ...]\n FROM { [ GROUP ] rolename | PUBLIC } [, ...]\n [ CASCADE | RESTRICT ]\n\nREVOKE [ GRANT OPTION FOR ]\n { USAGE | ALL [ PRIVILEGES ] }\n ON FOREIGN DATA WRAPPER fdwname [, ...]\n FROM { [ GROUP ] rolename | PUBLIC } [, ...]\n [ CASCADE | RESTRICT ]\n\nREVOKE [ GRANT OPTION FOR ]\n { USAGE | ALL [ PRIVILEGES ] }\n ON FOREIGN SERVER servername [, ...]\n FROM { [ GROUP ] rolename | PUBLIC } [, ...]\n [ CASCADE | RESTRICT ]\n\nREVOKE [ GRANT OPTION FOR ]\n { EXECUTE | ALL [ PRIVILEGES ] }\n ON FUNCTION funcname ( [ [ argmode ] [ argname ] argtype [, ...] ] ) [, ...]\n FROM { [ GROUP ] rolename | PUBLIC } [, ...]\n [ CASCADE | RESTRICT ]\n\nREVOKE [ GRANT OPTION FOR ]\n { USAGE | ALL [ PRIVILEGES ] }\n ON LANGUAGE langname [, ...]\n FROM { [ GROUP ] rolename | PUBLIC } [, ...]\n [ CASCADE | RESTRICT ]\n\nREVOKE [ GRANT OPTION FOR ]\n { { CREATE | USAGE } [,...] | ALL [ PRIVILEGES ] }\n ON SCHEMA schemaname [, ...]\n FROM { [ GROUP ] rolename | PUBLIC } [, ...]\n [ CASCADE | RESTRICT ]\n\nREVOKE [ GRANT OPTION FOR ]\n { CREATE | ALL [ PRIVILEGES ] }\n ON TABLESPACE tablespacename [, ...]\n FROM { [ GROUP ] rolename | PUBLIC } [, ...]\n [ CASCADE | RESTRICT ]\n\nREVOKE [ ADMIN OPTION FOR ]\n role [, ...] FROM rolename [, ...]\n [ CASCADE | RESTRICT ]") },

503

504

{ "ROLLBACK",

505

N_("abort the current transaction"),

506

N_("ROLLBACK [ WORK | TRANSACTION ]") },

507

508

{ "ROLLBACK PREPARED",

509

N_("cancel a transaction that was earlier prepared for two-phase commit"),

510

N_("ROLLBACK PREPARED transaction_id") },

511

512

{ "ROLLBACK TO SAVEPOINT",

513

N_("roll back to a savepoint"),

514

N_("ROLLBACK [ WORK | TRANSACTION ] TO [ SAVEPOINT ] savepoint_name") },

515

516

{ "SAVEPOINT",

517

N_("define a new savepoint within the current transaction"),

518

N_("SAVEPOINT savepoint_name") },

519

520

{ "SELECT",

521

N_("retrieve rows from a table or view"),

522

N_("[ WITH [ RECURSIVE ] with_query [, ...] ]\nSELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ]\n * | expression [ [ AS ] output_name ] [, ...]\n [ FROM from_item [, ...] ]\n [ WHERE condition ]\n [ GROUP BY expression [, ...] ]\n [ HAVING condition [, ...] ]\n [ WINDOW window_name AS ( window_definition ) [, ...] ]\n [ { UNION | INTERSECT | EXCEPT } [ ALL ] select ]\n [ ORDER BY expression [ ASC | DESC | USING operator ] [ NULLS { FIRST | LAST } ] [, ...] ]\n [ LIMIT { count | ALL } ]\n [ OFFSET start [ ROW | ROWS ] ]\n [ FETCH { FIRST | NEXT } [ count ] { ROW | ROWS } ONLY ]\n [ FOR { UPDATE | SHARE } [ OF table_name [, ...] ] [ NOWAIT ] [...] ]\n\nwhere from_item can be one of:\n\n [ ONLY ] table_name [ * ] [ [ AS ] alias [ ( column_alias [, ...] ) ] ]\n ( select ) [ AS ] alias [ ( column_alias [, ...] ) ]\n with_query_name [ [ AS ] alias [ ( column_alias [, ...] ) ] ]\n function_name ( [ argument [, ...] ] ) [ AS ] alias [ ( column_alias [, ...] | column_definition [, ...] ) ]\n function_name ( [ argument [, ...] ] ) AS ( column_definition [, ...] )\n from_item [ NATURAL ] join_type from_item [ ON join_condition | USING ( join_column [, ...] ) ]\n\nand with_query is:\n\n with_query_name [ ( column_name [, ...] ) ] AS ( select )\n\nTABLE { [ ONLY ] table_name [ * ] | with_query_name }") },

523

524

{ "SELECT INTO",

525

N_("define a new table from the results of a query"),

526

N_("[ WITH [ RECURSIVE ] with_query [, ...] ]\nSELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ]\n * | expression [ [ AS ] output_name ] [, ...]\n INTO [ TEMPORARY | TEMP ] [ TABLE ] new_table\n [ FROM from_item [, ...] ]\n [ WHERE condition ]\n [ GROUP BY expression [, ...] ]\n [ HAVING condition [, ...] ]\n [ WINDOW window_name AS ( window_definition ) [, ...] ]\n [ { UNION | INTERSECT | EXCEPT } [ ALL ] select ]\n [ ORDER BY expression [ ASC | DESC | USING operator ] [ NULLS { FIRST | LAST } ] [, ...] ]\n [ LIMIT { count | ALL } ]\n [ OFFSET start [ ROW | ROWS ] ]\n [ FETCH { FIRST | NEXT } [ count ] { ROW | ROWS } ONLY ]\n [ FOR { UPDATE | SHARE } [ OF table_name [, ...] ] [ NOWAIT ] [...] ]") },

527

528

{ "SET",

529

N_("change a run-time parameter"),

530

N_("SET [ SESSION | LOCAL ] configuration_parameter { TO | = } { value | 'value' | DEFAULT }\nSET [ SESSION | LOCAL ] TIME ZONE { timezone | LOCAL | DEFAULT }") },

531

532

{ "SET CONSTRAINTS",

533

N_("set constraint checking modes for the current transaction"),

534

N_("SET CONSTRAINTS { ALL | name [, ...] } { DEFERRED | IMMEDIATE }") },

535

536

{ "SET ROLE",

537

N_("set the current user identifier of the current session"),

538

N_("SET [ SESSION | LOCAL ] ROLE rolename\nSET [ SESSION | LOCAL ] ROLE NONE\nRESET ROLE") },

539

540

{ "SET SESSION AUTHORIZATION",

541

N_("set the session user identifier and the current user identifier of the current session"),

542

N_("SET [ SESSION | LOCAL ] SESSION AUTHORIZATION username\nSET [ SESSION | LOCAL ] SESSION AUTHORIZATION DEFAULT\nRESET SESSION AUTHORIZATION") },

543

544

{ "SET TRANSACTION",

545

N_("set the characteristics of the current transaction"),

546

N_("SET TRANSACTION transaction_mode [, ...]\nSET SESSION CHARACTERISTICS AS TRANSACTION transaction_mode [, ...]\n\nwhere transaction_mode is one of:\n\n ISOLATION LEVEL { SERIALIZABLE | REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED }\n READ WRITE | READ ONLY") },

547

548

{ "SHOW",

549

N_("show the value of a run-time parameter"),

550

N_("SHOW name\nSHOW ALL") },

551

552

{ "START TRANSACTION",

553

N_("start a transaction block"),

554

N_("START TRANSACTION [ transaction_mode [, ...] ]\n\nwhere transaction_mode is one of:\n\n ISOLATION LEVEL { SERIALIZABLE | REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED }\n READ WRITE | READ ONLY") },

555

556

{ "TABLE",

557

N_("retrieve rows from a table or view"),

558

559

560

{ "TRUNCATE",

561

N_("empty a table or set of tables"),

562

N_("TRUNCATE [ TABLE ] [ ONLY ] name [, ... ]\n [ RESTART IDENTITY | CONTINUE IDENTITY ] [ CASCADE | RESTRICT ]") },

563

564

{ "UNLISTEN",

565

N_("stop listening for a notification"),

566

N_("UNLISTEN { name | * }") },

567

568

{ "UPDATE",

569

N_("update rows of a table"),

570

N_("UPDATE [ ONLY ] table [ [ AS ] alias ]\n SET { column = { expression | DEFAULT } |\n ( column [, ...] ) = ( { expression | DEFAULT } [, ...] ) } [, ...]\n [ FROM fromlist ]\n [ WHERE condition | WHERE CURRENT OF cursor_name ]\n [ RETURNING * | output_expression [ [ AS ] output_name ] [, ...] ]") },

571

572

{ "VACUUM",

573

N_("garbage-collect and optionally analyze a database"),

574

N_("VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] [ table ]\nVACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] ANALYZE [ table [ (column [, ...] ) ] ]") },

575

576

{ "VALUES",

577

N_("compute a set of rows"),

578

N_("VALUES ( expression [, ...] ) [, ...]\n [ ORDER BY sort_expression [ ASC | DESC | USING operator ] [, ...] ]\n [ LIMIT { count | ALL } ]\n [ OFFSET start [ ROW | ROWS ] ]\n [ FETCH { FIRST | NEXT } [ count ] { ROW | ROWS } ONLY ]") },

579

580

{ "WITH",

581

N_("retrieve rows from a table or view"),

582

583

584

585

{ NULL, NULL, NULL } /* End of list marker */

586

};

587

588

589

#define QL_HELP_COUNT 140 /* number of help items */

590

#define QL_MAX_CMD_LEN 32 /* largest strlen(cmd) */

591

592

593

#endif /* SQL_HELP_H */

Older »