Thread: translating filenames into tablenames?

translating filenames into tablenames?

From

"Ed L."

Date:

11 February 2003, 17:08:12

Could someone point me to the docs or remind me of the tool that
allows me to translate filenames under $PGDATA/base/ into the
corresponding DB object name?  I know this is an FAQ, but I didn't
see it.

Thanks in advance.

Re: translating filenames into tablenames?

From

Dmitry Tkach

Date:

11 February 2003, 17:58:58

select relname from pg_class where oid = <filename_without_extension>

should do it...

I hope, it helps..

Dima

Ed L. wrote:
> Could someone point me to the docs or remind me of the tool that=20
> allows me to translate filenames under $PGDATA/base/ into the=20
> corresponding DB object name?  I know this is an FAQ, but I didn't=20
> see it.
>
> Thanks in advance.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

Re: translating filenames into tablenames?

From

Bruce Momjian

Date:

12 February 2003, 23:06:57

I think you want /contrib/oid2name.

---------------------------------------------------------------------------

Ed L. wrote:
>
> Could someone point me to the docs or remind me of the tool that
> allows me to translate filenames under $PGDATA/base/ into the
> corresponding DB object name?  I know this is an FAQ, but I didn't
> see it.
>
> Thanks in advance.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Re: translating filenames into tablenames?

From

Medi Montaseri

Date:

12 February 2003, 23:28:40

You can also write your own based on

The following that I call ols (oid ls)

----------------------------------- cut
----------------------------------------
#!/bin/bash

DIR=$1

cd $DIR
for file in `ls -S`
do
   psql -qc "select relid,relname from pg_stat_all_tables where
relid=$file" | grep $file
done

----------------------------------- cut again
--------------------------------------

yes, it  could be optimized...

Bruce Momjian wrote:

>I think you want /contrib/oid2name.
>
>---------------------------------------------------------------------------
>
>Ed L. wrote:
>
>
>>Could someone point me to the docs or remind me of the tool that
>>allows me to translate filenames under $PGDATA/base/ into the
>>corresponding DB object name?  I know this is an FAQ, but I didn't
>>see it.
>>
>>Thanks in advance.
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 4: Don't 'kill -9' the postmaster
>>
>>
>>
>
>
>