>
> I read recently about the efforts underway to COPY from a view,
> however I was wondering what the current best-practices are for being
> able to copy out of a view and import that data into an actual table
> elsewhere. I am currently doing psql -c "SELECT ..." and the using a
> bit of perl
On Tue, Jun 20, 2006 at 12:44:24PM -0700, Aaron Koning wrote:
> copyable, importable... into Excel or another postgres db?
Ofcourse. It doesn't have the table definition ofcourse, just the data.
The CSV format was added specifically for importing into Excel and
similar programs...
--
Martijn van
copyable, importable... into Excel or another postgres db?On 6/20/06, Martijn van Oosterhout wrote:On Tue, Jun 20, 2006 at 10:29:21AM -0700, Aaron Koning wrote:> CREATE TABLE sometable AS SELECT * FROM someview;
> pg_dump -t sometable dbname> DROP TABLE sometable>> Que? Si!Eh?
On Tue, Jun 20, 2006 at 10:29:21AM -0700, Aaron Koning wrote:
> CREATE TABLE sometable AS SELECT * FROM someview;
> pg_dump -t sometable dbname
> DROP TABLE sometable
>
> Que? Si!
Eh? If you're going to create the table anyway, I'd use psql:
psql -c "COPY table TO STDOUT"
If you put "CSV" there
CREATE TABLE sometable AS SELECT * FROM someview;
pg_dump -t sometable dbname
DROP TABLE sometable
Que? Si!On 6/20/06, Worky Workerson <[EMAIL PROTECTED]> wrote:
On 6/20/06, Aaron Koning <[EMAIL PROTECTED]> wrote:> google pg_dumpReally? What command do you use? I've tried the following:pg_du
On 6/20/06, Aaron Koning <[EMAIL PROTECTED]> wrote:
google pg_dump
Really? What command do you use? I've tried the following:
pg_dump -t viewname dbname
and I get the view definition, whereas I would like the data. Is
there an option to pg_dump that I'm missing?
--
google pg_dumpOn 6/20/06, Worky Workerson <[EMAIL PROTECTED]> wrote:
I read recently about the efforts underway to COPY from a view,however I was wondering what the current best-practices are for beingable to copy out of a view and import that data into an actual tableelsewhere. I am currently doi