On Thu, 2013-01-24 at 09:01 +0530, Shridhar Daithankar wrote: > On Wednesday, January 23, 2013 09:39:43 PM Gauthier, Dave wrote: > > Then someone who wants to look at old JAN data will have the same problem > > :-( > > > > If I recall, Oracle enables something like this. Multiple tnsfilenames (or > > something like that). There was a connect layer on the server side that > > the DBA had access to where you could do stuff like this. > > >> proposed new SQL command: > > >>READ USERS MIND; > > : > > :-) > > > > Actually, read the DBA's mind. > > > > How about... > > > > postgres=# create db_alias FEB to db JAN; > > postgres=# drop db_alias FEB; > > I would have suggested to use pg_services file as documented at > > http://www.postgresql.org/docs/9.1/static/libpq-pgservice.html > http://www.postgresql.org/docs/9.1/static/libpq-connect.html > > You can think of this as tnsnames replacement. > > but I am unable to make it work. I don't know what is wrong with this. > > shridhar@bheem ~$ cat ~/.pg_service.conf > [test1] > host=localhost > dbname=test > > shridhar@bheem ~$ strace -o psql.strace psql test1 > psql: FATAL: database "test1" does not exist >
