Re: re[ADMIN] store db from other db folder

2010-06-06 Thread mnavahan
No i have not any dump Scott Marlowe-2 wrote: > > On Fri, Jun 4, 2010 at 10:34 PM, mnavahan wrote: >> >> Hi >> >> (windows :: pg8.4.4 ::pgadmin 1.10) >> >> in old pc i had  3 different tablespace and each tablespace had one >> database &g

re[ADMIN] store db from other db folder

2010-06-04 Thread mnavahan
Hi (windows :: pg8.4.4 ::pgadmin 1.10) in old pc i had 3 different tablespace and each tablespace had one database Now i dont have old pc ! but i have copy of each tablespace . now in new pc i have installed the same version PG and need to rergister this 3 database how can i do it ? r

Re: [ADMIN] Firebird To postgresql migration help needed

2010-06-04 Thread mnavahan
Scott Marlowe-2 wrote: > > On Wed, May 19, 2010 at 10:38 AM, mnavahan wrote: >> >>>>I think so.  Look up "SECURITY DEFINER" >> >> seems goods i need try to it ... >> >> >>>>Not that I know of.  You're talking

Re: [ADMIN] Firebird To postgresql migration help needed

2010-05-19 Thread mnavahan
>>I think so. Look up "SECURITY DEFINER" seems goods i need try to it ... >>Not that I know of. You're talking connect / disconnect triggers right? YES how do it ? >>>I use nano or vi for most stuff. Both can do color coding quite nicely for .sql files. i need powerful IDE for i

[ADMIN] Firebird To postgresql migration help needed

2010-05-19 Thread mnavahan
I try to move from firebird to postgresql But it seems some option to do hold .. 1. In grant section in some reason user ROLE R1 can Access to function F1 and F1 can access to Table T1 bUT user must not be granted to work directly to table T1 In firebird ,I can invoke grant to object