[ADMIN] psql and lo_import

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://

[ADMIN] Operator *=

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)---

[ADMIN] Is there other benchmark tool than pgbench or xpgbench.

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

[ADMIN] REFRENTIAL INTEGRITY CHECKING

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.

Re: [ADMIN] psql and lo_import

"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

[ADMIN] Error Installing

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

[ADMIN] Re: how to get all system views and connections

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]

[ADMIN] Large objects

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

Re: [ADMIN] REFRENTIAL INTEGRITY CHECKING

--- 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

AW: [ADMIN] psql and lo_import

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

[ADMIN] Vacuum

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

[ADMIN] connect failure from psql`

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)--

Re: [ADMIN] REFRENTIAL INTEGRITY CHECKING

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

Re: [ADMIN] REFRENTIAL INTEGRITY CHECKING

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. > > > >

[ADMIN] how to connect remote database

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

Re: [ADMIN] psql and lo_import

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

Re: AW: [ADMIN] psql and lo_import

"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

Re: [ADMIN] Error Installing

"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

Re: [ADMIN] how to connect remote database

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

Re: [ADMIN] how to connect remote database

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)---

Re: AW: [ADMIN] psql and lo_import

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

Re: [ADMIN] Vacuum

"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

Re: [ADMIN] how to connect remote database

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