diff options
| author | Bruce Momjian <bruce@momjian.us> | 2004-10-06 17:43:07 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2004-10-06 17:43:07 +0000 |
| commit | a95a82e7f0a00b927f53f3c33eb831c9646c2c6f (patch) | |
| tree | 64c8191d212b5d0f6930ba1d99548cd7a65fa445 | |
| parent | d7b7a4a648f591e39f528b83241ce18f1efd913b (diff) | |
Uppercase SQL keywords in query for clarity.
| -rw-r--r-- | src/bin/pg_dump/pg_dump.c | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/src/bin/pg_dump/pg_dump.c b/src/bin/pg_dump/pg_dump.c index fce0b6e7767..2e446357d7a 100644 --- a/src/bin/pg_dump/pg_dump.c +++ b/src/bin/pg_dump/pg_dump.c @@ -12,7 +12,7 @@ * by PostgreSQL * * IDENTIFICATION - * $PostgreSQL: pgsql/src/bin/pg_dump/pg_dump.c,v 1.386 2004/08/29 05:06:53 momjian Exp $ + * $PostgreSQL: pgsql/src/bin/pg_dump/pg_dump.c,v 1.387 2004/10/06 17:43:07 momjian Exp $ * *------------------------------------------------------------------------- */ @@ -1395,15 +1395,15 @@ dumpBlobs(Archive *AH, void *arg) /* Cursor to get all BLOB tables */ if (AH->remoteVersion >= 70100) - appendPQExpBuffer(oidQry, "Declare blobOid Cursor for SELECT DISTINCT loid FROM pg_largeobject"); + appendPQExpBuffer(oidQry, "DECLARE bloboid CURSOR FOR SELECT DISTINCT loid FROM pg_largeobject"); else - appendPQExpBuffer(oidQry, "Declare blobOid Cursor for SELECT oid from pg_class where relkind = 'l'"); + appendPQExpBuffer(oidQry, "DECLARE bloboid CURSOR FOR SELECT oid from pg_class where relkind = 'l'"); res = PQexec(g_conn, oidQry->data); check_sql_result(res, g_conn, oidQry->data, PGRES_COMMAND_OK); /* Fetch for cursor */ - appendPQExpBuffer(oidFetchQry, "Fetch %d in blobOid", loFetchSize); + appendPQExpBuffer(oidFetchQry, "FETCH %d IN bloboid", loFetchSize); do { |