diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2014-07-10 15:01:31 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2014-07-10 15:01:43 -0400 |
| commit | 59efda3e50ca4de6a9d5aa4491464e22b6329b1e (patch) | |
| tree | 23a2fe16ebc11ad9f95ef3f70c563084d6ca4007 /src/bin/psql/tab-complete.c | |
| parent | 6a605cd6bd9f689b35676623add0de9b90978bf1 (diff) | |
Implement IMPORT FOREIGN SCHEMA.
This command provides an automated way to create foreign table definitions
that match remote tables, thereby reducing tedium and chances for error.
In this patch, we provide the necessary core-server infrastructure and
implement the feature fully in the postgres_fdw foreign-data wrapper.
Other wrappers will throw a "feature not supported" error until/unless
they are updated.
Ronan Dunklau and Michael Paquier, additional work by me
Diffstat (limited to 'src/bin/psql/tab-complete.c')
| -rw-r--r-- | src/bin/psql/tab-complete.c | 12 |
1 files changed, 10 insertions, 2 deletions
diff --git a/src/bin/psql/tab-complete.c b/src/bin/psql/tab-complete.c index bab03572352..6c2d431842c 100644 --- a/src/bin/psql/tab-complete.c +++ b/src/bin/psql/tab-complete.c @@ -876,8 +876,9 @@ psql_completion(const char *text, int start, int end) static const char *const sql_commands[] = { "ABORT", "ALTER", "ANALYZE", "BEGIN", "CHECKPOINT", "CLOSE", "CLUSTER", "COMMENT", "COMMIT", "COPY", "CREATE", "DEALLOCATE", "DECLARE", - "DELETE FROM", "DISCARD", "DO", "DROP", "END", "EXECUTE", "EXPLAIN", "FETCH", - "GRANT", "INSERT", "LISTEN", "LOAD", "LOCK", "MOVE", "NOTIFY", "PREPARE", + "DELETE FROM", "DISCARD", "DO", "DROP", "END", "EXECUTE", "EXPLAIN", + "FETCH", "GRANT", "IMPORT", "INSERT", "LISTEN", "LOAD", "LOCK", + "MOVE", "NOTIFY", "PREPARE", "REASSIGN", "REFRESH", "REINDEX", "RELEASE", "RESET", "REVOKE", "ROLLBACK", "SAVEPOINT", "SECURITY LABEL", "SELECT", "SET", "SHOW", "START", "TABLE", "TRUNCATE", "UNLISTEN", "UPDATE", "VACUUM", "VALUES", "WITH", @@ -2947,6 +2948,13 @@ psql_completion(const char *text, int start, int end) pg_strcasecmp(prev_wd, "GROUP") == 0) COMPLETE_WITH_CONST("BY"); +/* IMPORT FOREIGN SCHEMA */ + else if (pg_strcasecmp(prev_wd, "IMPORT") == 0) + COMPLETE_WITH_CONST("FOREIGN SCHEMA"); + else if (pg_strcasecmp(prev2_wd, "IMPORT") == 0 && + pg_strcasecmp(prev_wd, "FOREIGN") == 0) + COMPLETE_WITH_CONST("SCHEMA"); + /* INSERT */ /* Complete INSERT with "INTO" */ else if (pg_strcasecmp(prev_wd, "INSERT") == 0) |