Re: [ADMIN] Create database/table using postgresql stored function

2010-12-08 Thread Manasi Save
ng in mysql but I am not really sure is it possible in postgresql. -- Regards, Manasi Save On Wed, 08 Dec 2010 04:43:50 -0500, Manasi Save wrote: Hi All, I want to create postgresql database and tables using stored functions. Does postgresql support create statements in s

[ADMIN] Create database/table using postgresql stored function

2010-12-08 Thread Manasi Save
Hi All, I want to create postgresql database and tables using stored functions. Does postgresql support create statements in stored functions. Regards, Manasi

Re: [ADMIN] Creating multiple database at runtime in postgresql

2010-12-02 Thread Manasi Save
Thank you Julio. Could you provide me any reference link for understanding how to use postgresql schema? Regards, Manasi On Thu, 2 Dec 2010 14:11:40 +, Julio Leyva wrote: Probably what you need is to have a different schemes instead - From: manasi.s...

[ADMIN] Using dblink to access another posgresql database

2010-12-02 Thread Manasi Save
Hi All, I want to access different databases from one postgresql database stored function. Will this affect the performance of my database, as I need to specify host,port,dbname for each query. so will it be time consuming? Thanks in advance. Regards, Manasi

[ADMIN] using bytea data type

2010-12-02 Thread Manasi Save
Hi All, I have a postgresql database which has many columns in different tables with bytea data type. Can anyone provide me any input using the bytea data type for storing binary data provides how much benefit on performance as I have millions rows in a table using bytea data type also it is

[ADMIN] Creating multiple database at runtime in postgresql

2010-12-02 Thread Manasi Save
Dear All, I am new to postgresql database. I want to create an architecture wherein I want to create multiple databases at runtime. To be more description about the purpose, for example I am creating an account using any application which has postgresql as a backend. I want to create a new data

[ADMIN] Backup Postgres database remotely

2010-11-29 Thread Manasi Save
Hi All, I am new to postgresql. I have pgadmin installed on my windows machine locally using which i m connecting to the client server and accessing the database. I want to take the backup of client database. but it seems hard the database is very large. and when i select any database and hit b

[ADMIN] Using Postgresql Replication

2010-02-19 Thread Manasi Save
know if I am unclear in any point. Any input will be a great help. Thanks in advance. -- Regards, Manasi Save