Where does pgsql store the tables ?? - Mailing list pgsql-novice

From HK
Subject Where does pgsql store the tables ??
Date
Msg-id Pine.LNX.4.33.0209301308070.9243-100000@daisy.midascomm.com
Whole thread Raw
In response to Re: Executing multiple statements in a single query?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Where does pgsql store the tables ??  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
hi tom,
    Thanx for the reply. Thats wat i am doing. The problem was i didnt
wait for all the replies.
    I have two doubts.
1)  When a table is created in the database, in
    wat file does pg store the data. Also where are the index files
    stored.
2)  In asynchronous queries, can i dispense with pqflush(). If i can, what
    are all the cases where i can do so. On average my queries will be 8k
    in size.

thanx in advance.

--
regards
hari

On Wed, 25 Sep 2002, Tom Lane wrote:

> HK <harikrishnan@midascomm.com> writes:
> >     I am using postgresql from a c application with asyncronous Query
> > processing. Since only 1 query can be executed at a time, i am using  a
> > buffering mechanism to store the other queries generated at that time. Is
> > there any way i can execute all the statements in the buffer with a single
> > query.
>
> You can ship 'em all in a single PQsendQuery string, and wait for the
> successive results to come back.  Not sure if that's what you had in
> mind...
>
>             regards, tom lane
>



pgsql-novice by date:

Previous
From: "Mark Wilson"
Date:
Subject: Database Session Variables
Next
From: Tom Lane
Date:
Subject: Re: Where does pgsql store the tables ??