diff options
| author | Bruce Momjian <bruce@momjian.us> | 2001-01-24 03:40:33 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2001-01-24 03:40:33 +0000 |
| commit | a939e974519ec996b14367ca6cf1f9549b86dcdb (patch) | |
| tree | 40210c1b2c1965e68631fb9209fdccab610573e3 /contrib/oid2name | |
| parent | 2c591cb821dcf4ad5ee2502af1b809cae7ef90be (diff) | |
| download | postgresql-a939e974519ec996b14367ca6cf1f9549b86dcdb.tar.gz | |
Update
Diffstat (limited to 'contrib/oid2name')
| -rw-r--r-- | contrib/oid2name/Makefile | 2 | ||||
| -rw-r--r-- | contrib/oid2name/oid2name.c | 8 |
2 files changed, 5 insertions, 5 deletions
diff --git a/contrib/oid2name/Makefile b/contrib/oid2name/Makefile index 616e0da381..4303164d6a 100644 --- a/contrib/oid2name/Makefile +++ b/contrib/oid2name/Makefile @@ -2,7 +2,7 @@ # subdir = contrib/oid2name -top_builddir = /pgtop/ +top_builddir = ../.. include $(top_builddir)/src/Makefile.global override CPPFLAGS += -I$(libpq_srcdir) diff --git a/contrib/oid2name/oid2name.c b/contrib/oid2name/oid2name.c index ca5ca1d17d..6d2105d9b3 100644 --- a/contrib/oid2name/oid2name.c +++ b/contrib/oid2name/oid2name.c @@ -331,9 +331,9 @@ void sql_exec_dumptable(PGconn *conn, int systables) /* don't exclude the systables if this is set */ if(systables == 1) - sprintf(todo, "select oid,relname from pg_class order by relname"); + sprintf(todo, "select relfilenode,relname from pg_class order by relname"); else - sprintf(todo, "select oid,relname from pg_class where relname not like 'pg_%%' order by relname"); + sprintf(todo, "select relfilenode,relname from pg_class where relname not like 'pg_%%' order by relname"); sql_exec(conn, todo, NULL); } @@ -348,7 +348,7 @@ void sql_exec_searchtable(PGconn *conn, char *tablename) todo = (char *) malloc (1024); /* get the oid and tablename where the name matches tablename */ - sprintf(todo, "select oid,relname from pg_class where relname = '%s'", tablename); + sprintf(todo, "select relfilenode,relname from pg_class where relname = '%s'", tablename); returnvalue = sql_exec(conn, todo, 1); @@ -372,7 +372,7 @@ void sql_exec_searchoid(PGconn *conn, int oid) todo = (char *) malloc (1024); - sprintf(todo, "select oid,relname from pg_class where oid = %i", oid); + sprintf(todo, "select relfilenode,relname from pg_class where oid = %i", oid); returnvalue = sql_exec(conn, todo, 1); |