Just a note to clarify sqlplus
It does start in noautocommit as you say.
However, it issues a commit when you exit (with quit, Ctrl-D or whatever)
which is (in my opinion) incorrect, and very much worth taking into account
when writing scripts for Oracle.
I think it should automatically issue a r
On Tue, 24 Aug 2004, Stephen Kennedy wrote:
You are all right .However i was talking about the writing
shell scripts and running
psql -c
from it .THIS is a big problem if no autocommit is setted on
since at the end of the psql -c command there is a disconnect
and you have to add a commit to it B
Hi all!
such an easy question - i've dumped one of my postgresql databases in
one file names 'first'. So now i want to put the structure of this old
DB to another one named 'second'. How should i proceed with this?
Thanx in advance!
Edgars
---(end of broadcast)--
How can I do a test if my dumping is really working, I
can't apply the dump in my database, because it will
overwrite a lot of data. I was thinking about restore
in another database name, but I can't, it always
restore on the original database.
Somebody have a cooking recipe about to test if my
ba
Edgars wrote:
Hi all!
such an easy question - i've dumped one of my postgresql databases in
one file names 'first'. So now i want to put the structure of this old
DB to another one named 'second'. How should i proceed with this?
I think your question is not clear
If the 'first' is a database nam
On 24/08/2004 14:40 Eduardo S. Fontanetti wrote:
How can I do a test if my dumping is really working, I
can't apply the dump in my database, because it will
overwrite a lot of data. I was thinking about restore
in another database name, but I can't, it always
restore on the original database.
Someb
Assuming you're using Unix Box
1. Dump your database DB_X
pg_dump -v -U postgresUsername DB_X | gzip -f - > DB_X.gz
2.Create database DB_Y
psql -U postgresUsername template1
CREATE DATABASE DB_Y
\q
3. zcat DB_X.gz | psql -U postgresUsername -f - DB_Y
Thilina
-Original Message-
From: [E
I am using pg_dump.
It means that I can't restore to a different name
database??
Eduardo S. Fontanetti
--- Paul Thomas <[EMAIL PROTECTED]> escreveu:
>
> On 24/08/2004 14:40 Eduardo S. Fontanetti wrote:
> > How can I do a test if my dumping is really
> working, I
> > can't apply the dump in my
On Tue, 2004-08-24 at 17:36, Eduardo S. Fontanetti wrote:
> I am using pg_dump.
>
> It means that I can't restore to a different name
> database??
If you use pg_dump[all] without other options it will dump to a text
file. Just edit the database name.
--
Oliver Elphick
On Tue, Aug 24, 2004 at 07:25:46 +0100,
Mario Thomas <[EMAIL PROTECTED]> wrote:
> Hello All,
>
> We have a server in our datacentre running PostgreSQL 7.2 with about 50
> databases set up (for different customers). We have just commissioned a
> much better specified server which is running Postg
Quoth "Mario Thomas" <[EMAIL PROTECTED]>:
> We have a server in our datacentre running PostgreSQL 7.2 with about 50
> databases set up (for different customers). We have just commissioned a
> much better specified server which is running PostgreSQL 7.4.
>
> We need to migrate the databases from 7.2
Dear All,
Someone can help me to solve the below
problems
1. I create a table for a period of time,
there is huge records already posted.
I would like to alter table and add serial primary
key on that table. It's impossible to add serial no by hand. Please
adv how can I add the serial
Hello,
where i must place the .pgpass file under win32???
-
Thomas Wegner
Cabrio Meter - The Weather Plugin for Trillian
http://trillian.wegner24.de/cabriometer
---(end of broadcast)---
TIP 8: explain an
I use EMS PostgreSQL Manager. They has a graphical
Design Tool and many more.
-
Thomas Wegner
Cabrio Meter - The Weather Plugin for Trillian
http://trillian.wegner24.de/cabriometer
"Sanjay Arora" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
news:[EMAIL PRO
http://troels.arvin.dk/db/rdbms/
Try this..
Sanjay Arora wrote:
>Hi All
>
>Am looking for pointers to resouces that compare database naming, sql differences
>between mySQL & postgreSQL, for building a checklist for converting existing perl/php
>applications from mySQL to postgreSQL.
>
>Please
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sunday 22 August 2004 02:47 am, Keith wrote:
> Dear All,
>
> Someone can help me to solve the below problems
>
> 1. I create a table for a period of time, there is huge records already
> posted. I would like to alter table and add serial primary key
hi, somebody can help me???
I tried to create a new database but i can´t.
psql: FATAL: Database "template1" does not exist in the system catalog.
createdb: database creation failed
I tried to make initdb in another directory and it shows me Segmentation
Fault.
how i do to restore the template1?
Keith wrote:
> Dear All,
>
> Someone can help me to solve the below problems
>
> 1. I create a table for a period of time, there is huge records already
> posted.
> I would like to alter table and add serial primary key on that table.
> It's impossible to add serial no by hand. Please adv
On Sunday 22 August 2004 2:47 am, Keith wrote:
> Dear All,
>
> Someone can help me to solve the below problems
>
> 1. I create a table for a period of time, there is huge records
> already posted. I would like to alter table and add serial primary
> key on that table. It's impossible to add serial
You can also
$ cat dumpfile | more
--- Oliver Elphick <[EMAIL PROTECTED]> wrote:
> On Tue, 2004-08-24 at 17:36, Eduardo S. Fontanetti
> wrote:
> > I am using pg_dump.
> >
> > It means that I can't restore to a different name
> > database??
>
> If you use pg_dump[all] without other options it
20 matches
Mail list logo
