Re: [GENERAL] Questions about functionality

2005-02-04 Thread Karl O. Pinc
On 02/04/2005 10:06:49 AM, Ignacio Colmenero wrote: Hello. I have been in this list for a very short period of time so, if my questions have been answered before, please tell me and I will browse again in the archives. 1. Is there anything in Postgre or third-party solutions similar to Oracle's SQL

Re: [GENERAL] Questions about functionality

2005-02-04 Thread Bricklen Anderson
Karl O. Pinc wrote: 4. Can I query an object in another database, like in Oracle's dblink? I'm no expert. I don't believe so. You can query across scheams in the same database but not across databases. You could do something (anything!) by writing an external function in C or whatever, but I c

Re: [GENERAL] Questions about functionality

2005-02-04 Thread Scott Marlowe
On Fri, 2005-02-04 at 11:59, Karl O. Pinc wrote: > On 02/04/2005 10:06:49 AM, Ignacio Colmenero wrote: > > 4. Can I query an object in another database, like in Oracle's > > dblink? > > I'm no expert. I don't believe so. You can query across scheams > in the same database but not across datab

Re: [GENERAL] Questions about functionality

2005-02-04 Thread Michael Fuhr
On Fri, Feb 04, 2005 at 09:06:49AM -0700, Ignacio Colmenero wrote: > 1. Is there anything in Postgre or third-party solutions similar to Oracle's > SQL Loader, to upload a flat file into a table, according to certain rules? > Any solutions you have tried before to solve this issue? PostgreSQL (or

Re: [GENERAL] Questions about functionality

2005-02-04 Thread David Fetter
On Fri, Feb 04, 2005 at 09:06:49AM -0700, Ignacio Colmenero wrote: > Hello. > > I have been in this list for a very short period of time so, if my > questions have been answered before, please tell me and I will > browse again in the archives. > > 1. Is there anything in Postgre or third-party so

Re: [GENERAL] Questions about functionality

2005-02-06 Thread Christopher Browne
The world rejoiced as [EMAIL PROTECTED] ("Ignacio Colmenero") wrote: [Large amount of HTML removed... _Please_ post in plain text...] There is no direct analogue to Oracle's SQL*Loader product for PostgreSQL at this time. That being said... 1. Plenty of scripting languages are available for Un

Re: [GENERAL] Questions about functionality

2005-02-07 Thread Ignacio Colmenero
Just a small note to thank David Fetter, Michael Fuhr, Bricklen Anderson, Scott Marlowe, Karl O. Pinc, and Christopher Browne for their support and for helping me to understand a little bit more about PostgreSQL (I won't say Postgre anymore). Ignacio. -