psql -h -U
e.g. To connect to database customers on server gravy from server xxx :
psql customers -h gravy -U mypassword
-- rba
hth
Srinivasa R Chava wrote:
> Hai,
> How to connect the database from remote client ,using psql
> In oracle we use the command like the following one at sqlpl
"Chris Ruprecht" <[EMAIL PROTECTED]> writes:
> Can somebody explain to me what this vacuum is doing with all these
> files?
Just wasting space, I'm afraid. You may want to apply the patch at
http://www.ca.postgresql.org/mhonarc/pgsql-patches/2001-06/msg00061.html
However, if the database consi
berger, ralf writes:
> Because if I type \lo_import() in an insert statement:
>
> INSERT INTO test VALUES ( \lo_import('/home/torsten/bild1.gif') );
>
> I got a list of database owners and the following output:
>
> psql:lo_import.sql:1: \l: extra argument
> 'o_import('/home/torsten/bild1.gif')' i
Srinivasa R Chava writes:
> psql dabasename username@hostname
>
> It is not working.
psql --help
man psql
lynx /usr/local/pgsql/doc/html/index.html
--
Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter
---(end of broadcast)---
On Mon, 16 Jul 2001, Srinivasa R Chava wrote:
> Hai,
> How to connect the database from remote client ,using psql
> In oracle we use the command like the following one at sqlplus
> prompt.
> Sqlplus> username/password@hostname
>
> How to do it in postgresql
> I tried like this
> psql dabasename
"Matt" <[EMAIL PROTECTED]> writes:
> tab-complete.o(.text+0x2a36):tab-complete.c: undefined reference to
> `filename_completion_function'
Looks like a compatibility problem with libreadline. Which PG version
is this, and which version of libreadline do you have?
IIRC, libreadline 4.0 is not com
"berger, ralf" <[EMAIL PROTECTED]> writes:
> Any hint how to use this?
Get a more recent release...
regards, tom lane
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mp
berger, ralf writes:
> is there any way to use lo_import() in psql?
\lo_import filename [comment]
--
Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
h
Hai,
How to connect the database from remote client ,using psql
In oracle we use the command like the following one at sqlplus
prompt.
Sqlplus> username/password@hostname
How to do it in postgresql
I tried like this
psql dabasename username@hostname
It is not working.
Can anybody has an idea?
T
On Mon, 16 Jul 2001, Thalis A. Kalfigopoulos wrote:
> On 16 Jul 2001, Sudheer Palaparambil wrote:
>
> > Hi,
> >
> >How do we avoid referential integrity (FOREIGN KEY) checking till commit. My
>pgsql server
> > is checking it as soon as I am issueing an INSERT command. Pls help.
> >
> >
On 16 Jul 2001, Sudheer Palaparambil wrote:
> Hi,
>
>How do we avoid referential integrity (FOREIGN KEY) checking till commit. My
>pgsql server
> is checking it as soon as I am issueing an INSERT command. Pls help.
>
>Thanks in advance.
SET CONSTRAINTS TO DEFERRED
This will do the j
Hi,
We are trying to connect the postgresql datbase from out webserver , using psql .
In oracle , we use the syntax at sqlplus prompt like this
sqlplus> username/password@hostname.
How to do it in postgresql like this with psql utility.
Thanks
chava
---(end of broadcast)--
Hi fellow Postgressers
I have a relatively small database. The data itself
is about 1.5GB. After I did some index value changes over the weekend, I decided
that it's time to do a vacuum - the db had grown to 10 GB in size - which was
just unrealistic.
at 7:13 this otherwise fine morning, I
Hi,
> -Ursprüngliche Nachricht-
> Von: Tom Lane [mailto:[EMAIL PROTECTED]]
> Gesendet: Montag, 16. Juli 2001 19:38
> An: berger, ralf
> Cc: [EMAIL PROTECTED]
> Betreff: Re: [ADMIN] psql and lo_import
>
>
> "berger, ralf" <[EMAIL PROTECTED]> writes:
> > is there any way to use lo_import
--- Sudheer Palaparambil <[EMAIL PROTECTED]>
wrote:
> Hi,
>
>How do we avoid referential integrity (FOREIGN
> KEY) checking till commit. My pgsql server
> is checking it as soon as I am issueing an INSERT
> command. Pls help.
When you define the constraint, set it as INITIALLY
DEFERRED (or
Hi friends,
How to create large objects in pl/pgsql .There are example for
'libpq'. But I did not find any example for creating and using
large
objects with pl/pgsql.
Thanks
chava
--
Srinivasa R Chava (Chava) <[EMAIL PROTECTED]>
Application Developer
Corporate Intra/Internet Systems
WORLDCOM - h
guard wrote:
>
> thanks
>
> --
what was the reply? can you please send it to newsgroup?
kostis.
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Hi,
I get this error when using the "make" command in cygwin. I know it's the
GNU make command because I checked it using "make --version". Here is the
error:
gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations command.o common.o
hel
p.o input.o stringutils.o mainloop.o copy.o startup.o pr
"berger, ralf" <[EMAIL PROTECTED]> writes:
> is there any way to use lo_import() in psql?
See \lo_import
regards, tom lane
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(s
Hi,
How do we avoid referential integrity (FOREIGN KEY) checking till commit. My pgsql
server
is checking it as soon as I am issueing an INSERT command. Pls help.
Thanks in advance.
Sudheer
http://www.monsterindia.com - The Best Jobs.
Hi,
I'm benchmarking PostgreSQL for performance tunning.
But it seems that the pgbench and xpgbench are good benchmark tools
but so simple.
Where can I get other benchmark tools the pgbench or xpgbench.
Thx.
---(end of broadcast)---
TIP 2: you can
Hello
I know that exists a script file in postgres (I think) that have all of
these operators. But what is the name of the file ?
Is it in the package of postgresql by defualt ? If not, can someone send
me that file ?
Thanks
Luis Sousa
---(end of broadcast)---
Hi,
is there any way to use lo_import() in psql?
Thanx
Ralf
--
Fraunhofer IPK
Automatisierung und Robotik
Dipl.-Inf. Ralf Berger
Pascalstr. 8-9
10587 Berlin
Tel.: ++49-(0)30 390 06 129
Mobile: ++49-(0)175 52 50 118
Fax.: ++49-(0)30 391 10 37
Web : http://www.ar.ipk.fhg.de
Web : http://
23 matches
Mail list logo