Thread: some samll questions on postgres
hi, I am new to this database can any body help me out by answering some small questions.I am coming from SQLserver2k. I have installed postgres on windows2000 server.I am able to get pgAdminIII console. I have created some databases on postgres using pgAdminIII.But i want to know certain facts:- 1.Where are the datafiles and log files created? what is the concept of pg_default and pg_global(tablespaces). 2.Where we write the stored procedure in postgres? and most importantly 3.How to generate sql scripts of the databases? regards, ashish _________________________________________________________________ Stock Market�difficult? http://www.sharekhan.com/campaign/OpenNewAccount.asp?ProdID=23&SrcID=59 Not anymore. Join Sharekhan�s FirstStep
Regarding array of parameter passing from application to the database
From
"ashish srivastava"
Date:
Hi, can anybody help me in passing an array of parameters to the postgresql functions. I am having multiple check boxes on the UI and searching in the database on the basis whichever is the user selection criterion.. Thanks, Ashish _________________________________________________________________ NRIs, does your family in India need money urgently? Open an ICICI Bank NRI savings A/c http://creative.mediaturf.net/creatives/icicibank/ICICI_NRI_ERA.htm
On Tue, Oct 11, 2005 at 07:24:52PM +0530, ashish srivastava wrote: > can anybody help me in passing an array of parameters to the postgresql > functions. What functions? Server-side functions that you've created? What argument types do those functions take? Arrays of some base type? > I am having multiple check boxes on the UI and searching in the database on > the basis whichever is the user selection criterion.. What client-side language are you using? How are you receiving the checkbox choices? As an array with the selected elements? If your API can't automatically create a PostgreSQL array from a client language array, then you could build a string that represents the array using one of the formats described in the "Arrays" section of the PostgreSQL documentation: http://www.postgresql.org/docs/8.0/interactive/arrays.html If that's not what you're looking for then please provide more information. BTW, this seems off-topic for pgsql-admin. Pgsql-interfaces, pgsql-general, pgsql-novice, or perhaps pgsql-php (if you're using PHP) would be more appropriate. -- Michael Fuhr
i am using java to pass the parameter to the database and my client side lanugaue is flash. >From: Michael Fuhr <mike@fuhr.org> >To: ashish srivastava <ashu_shri@hotmail.com> >CC: pgsql-admin@postgresql.org >Subject: Re: [ADMIN] Regarding array of parameter passing from application >to the database >Date: Wed, 12 Oct 2005 00:13:22 -0600 > >On Tue, Oct 11, 2005 at 07:24:52PM +0530, ashish srivastava wrote: > > can anybody help me in passing an array of parameters to the postgresql > > functions. > >What functions? Server-side functions that you've created? What >argument types do those functions take? Arrays of some base type? > > > I am having multiple check boxes on the UI and searching in the database >on > > the basis whichever is the user selection criterion.. > >What client-side language are you using? How are you receiving the >checkbox choices? As an array with the selected elements? If your >API can't automatically create a PostgreSQL array from a client >language array, then you could build a string that represents the >array using one of the formats described in the "Arrays" section >of the PostgreSQL documentation: > >http://www.postgresql.org/docs/8.0/interactive/arrays.html > >If that's not what you're looking for then please provide more >information. > >BTW, this seems off-topic for pgsql-admin. Pgsql-interfaces, >pgsql-general, pgsql-novice, or perhaps pgsql-php (if you're using >PHP) would be more appropriate. > >-- >Michael Fuhr > >---------------------------(end of broadcast)--------------------------- >TIP 5: don't forget to increase your free space map settings _________________________________________________________________ Tata Racing is giving away racing goodies. Enter contest now. http://server1.msn.co.in/sp05/tataracing/contest.asp