its given in the psql admin docs.
it uses split .
regds
mallah.
On Thursday 12 December 2002 07:20 am, Christopher Smith wrote:
> Upon each postgresql upgrade the copy command seems just not to parse
> correctly. Of course, you say why not copy data into sql statements... I
> would however, the
Anyone? Bueller?
What's the usefulness of dumping data (-d/D) and oids (-o) separately?
Should I scrap the extra step for oids? If not what order should I
restore them in? Other than asking people who were around when the stuff
was created, how would I know if I need to dump oids separately?
J
Just complie the source and install it, don't do an initdd and add it to
your path :
psql -h
Khat
From: Aravind Vinnakota <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [ADMIN] client for solaris Date: Thu, 12 Dec 2002 18:52:00 -0500
(EST)
Hi all,
I am looking for a postgreSQL cl
Hi all,
I am looking for a postgreSQL client (okay with command line client) for
installing on a Solaris 8 machine. The basic idea is to use the client and
retreive the data from a database running on another machine. So, I want
to know where I can get the client (url) for solaris? I dont want al
On Thu, 2002-12-12 at 14:50, Robert Treat wrote:
> On Thu, 2002-12-12 at 01:39, Mukund Pate wrote:
> > hello,
> >
> > how to modify the datatype of column in a table?
> >
> > i have created table with one coulmn datatype is varchar(200) so i
> > would like to change to text datatype
> >
>
> You
On Thu, 2002-12-12 at 01:39, Mukund Pate wrote:
> hello,
>
> how to modify the datatype of column in a table?
>
> i have created table with one coulmn datatype is varchar(200) so i
> would like to change to text datatype
>
You will need to recreate the table.
Robert Treat
-
Arne Roolfs <[EMAIL PROTECTED]> writes:
> after compiling and installing postgresql 7.3 i tried to dump the old
> database of the running 7.1-server with "pg_dumpall -o > test" of the
> new version like recommendend by the "INSTALL"-file.
> it answered:
> bash$ /usr/local/pgsql-7.3/bin/pg_dumpal
hello,
after compiling and installing postgresql 7.3 i tried to dump the old
database of the running 7.1-server with "pg_dumpall -o > test" of the
new version like recommendend by the "INSTALL"-file.
it answered:
bash$ /usr/local/pgsql-7.3/bin/pg_dumpall -o > test
pg_dump: column number -1 is o
