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
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
Emi Lu wrote:
Florian G. Pflug wrote:
snipped code of stored procedure
Are you aware of the insert into table (field1, ..., fieldn)
select val1, .., valn 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 insert
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
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
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 existing
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
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 as
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
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
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
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
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:
Matthew T. O'Connor matthew@zeut.net 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
14 matches
Mail list logo