Craig Ringer wrote:
On 19/01/2010 1:13 AM, Vincenzo Romano wrote:
Another case, Tom, could be when the file is updated from a non-DB
application and you need to synchronize
the data with other DB applications ...
How can that work without a transactional file system, though? If the
external
van M
Cc: pgsql-general@postgresql.org
Date: 01/19/2010 05:31 PM
Subject: Re: [GENERAL] postgres external table
On 19 Jan 2010, at 12:16, Jayadevan M wrote:
> Yes. We get quite a few files as 'feeds' from external systems. Once the
files are in our network, we know tha
On 19 Jan 2010, at 12:16, Jayadevan M wrote:
> Yes. We get quite a few files as 'feeds' from external systems. Once the
> files are in our network, we know that no changes will happen to those files.
> We access them using Oracle external tables and process them (the data, after
> some processi
al
tables were not there, we would have had to schedule some job to load
these files.
Jayadevan
From: Greg Stark
To: Craig Ringer
Cc: Vincenzo Romano , Tom Lane
, Greg Smith , Amy Smith
, pgsql-general@postgresql.org
Date: 01/19/2010 04:37 PM
Subject: Re: [GENERAL
On Tue, Jan 19, 2010 at 4:41 AM, Craig Ringer
wrote:
> How can that work without a transactional file system, though? If the
> external process writes to the file while you're half-way through reading
> it, what's the database to do? In general, how do external tables cope with
> the fact that the
lowed
and so forth.
http://www.adp-gmbh.ch/ora/misc/ext_table.html
Other than that, I have not found any advantage.
Jayadevan
From: Tom Lane
To: Greg Smith
Cc: Craig Ringer , Amy Smith
, pgsql-general@postgresql.org
Date: 01/18/2010 08:25 PM
Subject: Re: [GENERAL] postgre
On 19/01/2010 1:13 AM, Vincenzo Romano wrote:
Another case, Tom, could be when the file is updated from a non-DB
application and you need to synchronize
the data with other DB applications ...
How can that work without a transactional file system, though? If the
external process writes to the
2010/1/18 Tom Lane :
> Greg Smith writes:
>> Craig Ringer wrote:
>>> For those non-Oracle users among us, what's an external table?
>
>> External tables let you map a text file directly to a table without
>> explicitly loading it. In PostgreSQL, if you have data in a CSV file,
>> usually you'd im
Tom Lane wrote:
I'm finding it hard to visualize a use-case for that. We must postulate
that the table is so big that you don't want to import it, and yet you
don't feel a need to have any index on it. Which among other things
implies that every query will seqscan the whole table. Where's the
On Mon, Jan 18, 2010 at 7:57 AM, Tom Lane wrote:
> Greg Smith writes:
>> Craig Ringer wrote:
>>> For those non-Oracle users among us, what's an external table?
>
>> External tables let you map a text file directly to a table without
>> explicitly loading it. In PostgreSQL, if you have data in a
On Mon, Jan 18, 2010 at 2:57 PM, Tom Lane wrote:
> I'm finding it hard to visualize a use-case for that. We must postulate
> that the table is so big that you don't want to import it, and yet you
> don't feel a need to have any index on it. Which among other things
> implies that every query wil
On Mon, Jan 18, 2010 at 09:57:02AM -0500, Tom Lane wrote:
> Greg Smith writes:
> > Craig Ringer wrote:
> >> For those non-Oracle users among us, what's an external table?
>
> > External tables let you map a text file directly to a table without
> > explicitly loading it. In PostgreSQL, if you h
Greg Smith writes:
> Craig Ringer wrote:
>> For those non-Oracle users among us, what's an external table?
> External tables let you map a text file directly to a table without
> explicitly loading it. In PostgreSQL, if you have data in a CSV file,
> usually you'd import it with COPY before yo
Craig Ringer wrote:
For those non-Oracle users among us, what's an external table?
External tables let you map a text file directly to a table without
explicitly loading it. In PostgreSQL, if you have data in a CSV file,
usually you'd import it with COPY before you'd use it. If external
ta
On Sun, Jan 17, 2010 at 07:27:34PM -0800, Amy Smith wrote:
> all
> is there a external table create method ( similar to oracle external table )
> ? where to find the information ?
There is a project on pgfoundry which has had some activity lately
that's similar. You might also try DBI-Link.
Chee
Amy Smith wrote:
> all
> is there a external table create method ( similar to oracle external
> table ) ? where to find the information ?
For those non-Oracle users among us, what's an external table? What are
you trying to achieve?
Random guess: you might be looking for tablespaces.
--
Craig Ri
16 matches
Mail list logo
