On Tue, Jan 19, 2010 at 4:41 AM, Craig Ringer
cr...@postnewspapers.com.au 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
Smith
vah...@gmail.com, pgsql-general@postgresql.org
Date: 01/19/2010 04:37 PM
Subject:Re: [GENERAL] postgres external table
Sent by:pgsql-general-ow...@postgresql.org
On Tue, Jan 19, 2010 at 4:41 AM, Craig Ringer
cr...@postnewspapers.com.au wrote:
How can that work without
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 processing,
To: Jayadevan M jayadevan.maym...@ibsplc.com
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
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
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
Greg Smith g...@2ndquadrant.com 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
On Mon, Jan 18, 2010 at 09:57:02AM -0500, Tom Lane wrote:
Greg Smith g...@2ndquadrant.com 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
On Mon, Jan 18, 2010 at 2:57 PM, Tom Lane t...@sss.pgh.pa.us 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
On Mon, Jan 18, 2010 at 7:57 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Greg Smith g...@2ndquadrant.com 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
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
2010/1/18 Tom Lane t...@sss.pgh.pa.us:
Greg Smith g...@2ndquadrant.com 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 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
@postgresql.org
Date: 01/18/2010 08:25 PM
Subject:Re: [GENERAL] postgres external table
Sent by:pgsql-general-ow...@postgresql.org
Greg Smith g...@2ndquadrant.com writes:
Craig Ringer wrote:
For those non-Oracle users among us, what's an external table?
External tables let you map
all
is there a external table create method ( similar to oracle external table )
? where to find the information ?
thanks
Amy
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
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.
17 matches
Mail list logo