Hi All.!
I just want to know one thing that is it possible with PGSQL that,
if I want to insert and execute a query from a external text file instead of giving it at the pgsql prompt?
just like in Oracle the file having query is executed with a '@ filename' statement at the sql prompt..
inside psql, type :
\i filename
On Sat, 11 Mar 2006 11:29:20 +0100, AKHILESH GUPTA
<[EMAIL PROTECTED]> wrote:
Hi All.!
I just want to know one thing that is it possible with PGSQL that,
if I want to insert and execute a query from a external text file
instead of
giving it at t
Emi Lu wrote:
>> Florian G. Pflug wrote:
>> < snipped code of stored procedure >
Are you aware of the "insert into (, ..., )
select , .., from "
command? It'd be much faster to use that it it's possible...
>>>
>>> It did faster. Thank you Florian. Could you hint me why "i
In the last exciting episode, [EMAIL PROTECTED] wrote:
> hallo, I am working with a group on a Gradute project and we use the
> PostgreSQL database for build an information system for a school.
> we have a small question:
> - Can the PostgreSQL store the Multimedia files ( Images ,video
> ,audio...
Hi all,
I am new to pgsql family.I had a problem with
installing postgres8.1 i was getting the following
error at the 4th step of installation the error is as
follows:
Data directory error:
The specified data directory is not empty
If you have an existing database with teh same
major ver
venu gopal schrieb:
> Hi all,
> I am new to pgsql family.I had a problem with
> installing postgres8.1 i was getting the following
> error at the 4th step of installation the error is as
> follows:
>
> Data directory error:
> The specified data directory is not empty
>
>If you have an e
I need to insert a row, but how that row is inserted depends on the
number of items existing in the table. I initially thought
SERIALIZABLE would help, but that only keeps me from seeing changes
until the commit in that session.
Am I correct that if I need to insert a row into a table that contai
Hi Tino Wildenhain,
Sorry for irritating you with my problems.Every
time i run my installing it gives different problems
and rolls back.Once when i move with account name as
postgres it gives problem as "user account exists"
and rollsback.
If i try with different user it gives problem a
On Fri, Mar 10, 2006 at 01:59:13PM +1100, Chris wrote:
> xia_pw wrote:
> > Hi,I have read the source codes of pgsql these days,and I want to know
> > which part of the source codes deal with the function of executing the
> > sql(select,alter,and so on),and which function deal with the query
>
I need to access PostgreSQL on a low level using libpq.dll.
Are there any programmers using Delphi here? Free Pascal users is also fine.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose a
So whats the problem?
Frank Church schrieb:
I need to access PostgreSQL on a low level using libpq.dll.
Are there any programmers using Delphi here? Free Pascal users is also fine.
---(end of broadcast)---
TIP 9: In versions below 8.0, the plan
I administer a network where a postgres database on one machine is
nightly dumped to another machine where it is restored (for
verification purposes) once the dump completes. The process is roughly:
pg_dump remotedb
dropdb localdb
pg_restore remotedb.pgd
We recently upgraded the system to 8.
Thomas F. O'Connell wrote:
I administer a network where a postgres database on one machine is
nightly dumped to another machine where it is restored (for verification
purposes) once the dump completes. The process is roughly:
pg_dump remotedb
dropdb localdb
pg_restore remotedb.pgd
We recently
On Mar 11, 2006, at 2:44 PM, Matthew T. O'Connor wrote:
Thomas F. O'Connell wrote:
I administer a network where a postgres database on one machine is
nightly dumped to another machine where it is restored (for
verification purposes) once the dump completes. The process is
roughly:
pg_dum
"Matthew T. O'Connor" writes:
> I suppose you could instead:
> connect to local postmaster
> disable autovacuum
> pg_dump remotedb
> dropdb localdb
> pg_restore remotedb.pgd
> enable autovacuum
For a "real" solution, perhaps DROP DATABASE could somehow look to
determine if there's an autovac dae
15 matches
Mail list logo