[GENERAL] Using AND in query

Hello every one, I have encountered a problem while working .I have a sample table with the following data TID Date Item T100 8/1/2010 Laptop T100 8/1/2010 Desktop T101 8/1/2010 Laptop T102 8/1/2010 Desktop T103 8/2/2010 Laptop T103 8/2/2010 Desktop T104 8/2/2010 Laptop   need the 

[GENERAL] Query to find list of dates between two dates

Hello guys, can you please help me with the following query I need a query that displays all the dates in between two dates say i give two dates 12/1/2009 and 12/31/2009 The result should be like this 12/1/2009 12/2/2009 12/3/2009 . . . . . 12/31/2009 Note : Assume that there is no table

[GENERAL] Error while including PQXX library

Hello,   I wrote a small program in cpp which uses pqxx API.The file that i included are         #include pqxx/connection   #include pqxx/transaction   After compiling i got the following error :     prog29.cpp:5:21: pqxx/connection: No such file or

[GENERAL] Data in a table to a csv file

Hello, I have a small problem,I need to export data from a table into a csv file.For this i am using pqxx library to work on it.I can able to retrieve the data from the database but the only problem is I am unable to store it in a csv file.Can you guys please help me how to do that.

[GENERAL] Problem with pgpool-II tool

Hello, I have encountered a problem while configuring pgpool-II,I encountered a problem while executing the following command. pgpool -n [1] 2796 [achand...@localhost ~]$ pool_config: could not open configuration file (pgpool.conf) pool_config: using default values... pid file

[GENERAL] In memory Database for postgres

: [GENERAL] In memory Database for postgres 2009/4/12 John R Pierce pie...@hogranch.com: aravind chandu wrote: I created in-memory database but the problem is all the data will be accessed from main memory .when ever the system is restarted the entire data that is in the tables

Re: [GENERAL] In memory Database for postgres

to think about it maybe anybody know how to restore db when the in memory schema was damaged? Regards, Blazej 2008/11/17 aravind chandu avin_frie...@yahoo.com: Hello, I guess most of you guys heard about In Memory Database.I have a small question regarding it.I need to create

[GENERAL] Parallel DB architechture

Hello, I would like to implement parallel DB Architecture in postgres.I came across various parallel architectures shared memory,shared disk,shared nothing,hierarchical.But I am unaware of how to implement one of these in real time system.Can you guys help me in this aspect?

[GENERAL] Parallel Query Processing

? From: Scott Marlowe scott.marl...@gmail.com To: aravind chandu avin_frie...@yahoo.com Cc: postgresql Forums pgsql-general@postgresql.org Sent: Wednesday, March 25, 2009 4:52:43 PM Subject: Re: [GENERAL] Parallel Query Processing On Wed, Mar 25, 2009 at 2:24 PM

[GENERAL] Parallel Query Processing

Hello, I have a few questions related to the parallel query processing.Can you guys tell me how to implement parallel query processing in postgresql database. Thanks, Avin.

Re: [GENERAL] Syntax error with select statement

like: aravind chandu wrote: Hello, I have problem with select statement in c++ program I am using pqxx library to connect to postgresql database.My query is result R(T.exec( select * from dbtable where username = ' +user+ ' and password = ' +st

[GENERAL] Syntax error with select statement

Hello, I have problem with select statement in c++ program I am using pqxx library to connect to postgresql database.My query is result R(T.exec( select * from dbtable where username = ' +user+ ' and password = ' +st+ ' )); here st is in encrypted format and

[GENERAL] Problem Related to storing the field value in a String

Hello Guys, The following is my sample program result R(T.exec(select * from emp)); string L; stringstream S; vectorstring v; int z,i; z = R.size(); for (i = 0;iz ;i++){ // Write field's string into S S R[i][0]; // Parse contents of S into L S L; v.push_back(L);

[GENERAL] In memory Database for postgres

Hello,   I guess most of you guys heard about In Memory Database.I have a small question regarding it.I need to create an In Memory Database for postgresql through which I have to perform various operations on postgresql  database(queries,procedures,programs using pqxx API etc...).I

[GENERAL] Need Help for a query

Hello,     I am using this pqxx library for postgresql to run programs.The following is the query which i gave to store the data,here data.speed,data.heading are float values and data.ttime is timestamp .If i try to run this statement I end up with an error below this query.Please help

[GENERAL] Username and Password authentication using pqxx library.

Hello, I am using pqxx API for postgresql.The following is the part of my code.The problem is in the query I am selecting the number of rows from the table since there is only one user name and password row it should return 1 and if there is no match then it should return 0.But

[GENERAL] size of a table on postgresql

Hello,   The following is the procedure to calculate the disk space occupied by postgresql from a flat file. In this I didn't understood some terms  24 bytes: each row header (approximate) 24 bytes: one int field and one text field + 4 bytes: pointer on page to

[GENERAL] How to calculate number of rows per page in postgresql

Hello,   The following is the procedure to calculate the disk space occupied by postgresql from a flat file.  http://www.postgresql.org/docs/faqs.FAQ.html#item4.5 In this I didn't understood some terms  24 bytes: each row header (approximate) 24 bytes: one int field and

[GENERAL] Disk space occupied by a table in postgresql

Hello, I installed postgresql on linux system, I create a table and inserted a large data into the table what I would like to know is how to calculate the disk space occupied by the table .Is there any procedure to find it out or simply a command .Please give me some

[GENERAL] should i need to install xml library in postgresql inorder to work on xml file?

Hello,     I installed postgresql on my sytem,I need to parse an xml file.When I am working on xpath() it is showing an error that function is notfound and i tried almost all xml functions in postgresql but it is giving me the same result.why so ? should I have to install any xml

[GENERAL] errors while working on xml functions in postgresql

Hello,     I installed postgresql on my sytem,I need to parse an xml file.When I am working on xpath() it is showing an error that function is notfound and i tried almost all xml functions in postgresql but it is giving me the same result.why so ? should I have to install any xml

[GENERAL] How to give input a file for a stored procedure

Hi, I am writing a stored procedure where the input to it is a file.I did not have any idea of how to give input as a file for a stored procedure.could you please help me. Thank You, Avin.

[GENERAL] Getting data from Xml to Postgresql database

Hi, I have some data in XML format and i need to upload in postgresql database using stored procedure. Can someone tell me the step by step procedure of the same as i will be doing it for the first time. Thank You, Avin.

[GENERAL] procedure to load xml file data in postgesql

Hello, I have to load xml file data into postgresql database table using a stored procedure,but I didn't have any idea how to start it.Can you please help me how to do this.Your suggestion is greatly appreciated.Its very important to me. Thanks in advance, Avin. ?xml

[GENERAL] REQUIREMENTS FOR POSTGRESQL DATABASE

Hello, I just need the information related to the requirements of postgresql database like how much size it occupies on the disk (when it is installed) irrespective of tables size and how much RAM is needed for better performance of the database say, I have 4gb ram will it use

[GENERAL] SPACE FOR POSTGRESQL DATABASE

Hello,     Can you please how much space does postgresql database occupies? Thank You, Aviansh

[GENERAL] information related to blobs

Hello,   Blobs stores large amount can you please tell me what is the limit i.e hw many kb of data can it store ? say 4000k like that. For suppose if a 4000kb data can be stored using blob and the data stored in blob is 3600k what about the remaining data? will it allocates

[GENERAL] predefined animation and pre-recorded sounds in postgresql

Hello,     I just need to load pre-defined animations and pre-recorded sounds in postgresql.Can you please tell how to do this.I appreciate your help. Thank You, Aravind.

[GENERAL] To store and retrive image data in postgresql

Hello,   I need to store an image in postgresql database and after that i need to retrive the image back.Can you please help me how to do this? Thank You, Avinash.

[GENERAL] xml and postgresql

Hi folks, I need to load xml data in to database can you tell me they way how do I import xml data into postgresql database. lets dat this is the xml file bookstore book category=CHILDREN titleHarry Potter/title authorJ K. Rowling/author year2005/year

[GENERAL] does postgresql works on distributed systems?

Hi, nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; My question is nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; Microsoft sql server 2005 cannot be shared on multiple systems i,e in a network environment when it is installed in one system it cannot be accessed one other systems.One can access only