[ADMIN] help pls

2005-12-01 Thread sandhya
hi..   I want to know more about this export and import large objects..viewing it's contents etc..Where can i found? I have gonethrough, http://www.postgresql.org/docs/8.0/interactive/largeobjects.html    Creating a Large Object   Importing a Large Object  Exporting a Large Object    Is

[ADMIN] reg:File import&export problem

2005-12-01 Thread sandhya
  Hi ...   Pls tell me...how to do this? I have to import and export files from/to a database. Say i have a file named "sample" (assume some path) and i want to store it in to a database. I did this through lo_import function and i got the object id  when i have used.the following op

[ADMIN] Input on certification requirements

2005-12-01 Thread Jeff Frost
One of the clients I am currently working with is developing a PostgreSQL certification curriculum, so I'm here to solicit for ideas on what you folks think would be absolutely expected of someone with a certification in PostgreSQL. Also, suggestions on other lists I should post this request w

Re: [ADMIN] Reg: File import&export problem

2005-12-01 Thread Guido Barosio
Hi SandhyaYour request, again, seems to be poor in terms of information to the mailing list.I would sugest you to write this mail again, including the command's being run, and describing the idea behind them. That would be a good start :) Best wishes,GuidoOn 12/1/05, sandhya <[EMAIL PROTECTED]> wro

Re: [ADMIN] reg:large object OID

2005-12-01 Thread Guido Barosio
sandhya,    your question / request is not clear at all. Please explain us all here, which are your needs, and we'll kindly assist you if we can.   Best regards,Guido.On 12/1/05, sandhya <[EMAIL PROTECTED]> wrote: hi   After getting OID is there any way to see the contents of it? Pleas

Re: [ADMIN] old database dump.

2005-12-01 Thread Theo Galanakis
Thanks Tom and Paul for your advice. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane Sent: Friday, 2 December 2005 2:40 AM To: pgsql-admin@postgresql.org Subject: Re: [ADMIN] old database dump. Paul Breen <[EMAIL PROTECTED]> writes: > Alternativ

Re: [ADMIN] --with-perl

2005-12-01 Thread Joshua D. Drake
Dan The Man wrote: Hi, I didn't build (./configure --with-perl) the makefile with perl and a developer wants it now. Is there a way to add perl with out a complete re-instsall like with the create lang command? Has anyone read anything about about the perl PL ? Someone in our group said he r

Re: [ADMIN] old database dump.

2005-12-01 Thread Tom Lane
Paul Breen <[EMAIL PROTECTED]> writes: > Alternatively you can login with your password as > normal and then once in psql use the '\i filename' > command to read in your backup. Or use "psql -f file" instead of "psql < file". regards, tom lane ---(

[ADMIN] --with-perl

2005-12-01 Thread Dan The Man
Hi, I didn't build (./configure --with-perl) the makefile with perl and a developer wants it now. Is there a way to add perl with out a complete re-instsall like with the create lang command? Has anyone read anything about about the perl PL ? Someone in our group said he read its really archai

[ADMIN] reg:large object OID

2005-12-01 Thread sandhya
hi   After getting OID is there any way to see the contents of it? Please tell me.     -Sandhya

[ADMIN] Reg: File import&export problem

2005-12-01 Thread sandhya
Hi...   Please help me in sorting out the below problem. While doing importing and expoting files(This is first time i am using this concept)..i got the following error message. Anything i have to include? How to rectify it? pls tell me to proceed further...     : undefined reference to

Re: [ADMIN] old database dump.

2005-12-01 Thread Paul Breen
Alternatively you can login with your password as normal and then once in psql use the '\i filename' command to read in your backup. E.g., psql dbname Password: dbname=# \i database.bak dbname=# \q Regards - Paul Breen --- Jeff Frost <[EMAIL PROTECTED]> wrote: > Use the .pgpass file. > > On Th