Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2002
    Location
    Calgary, Canada
    Posts
    30

    Unanswered: Export functions

    Hi all

    Is there a way that will allow me to select what columns I want exported from a table?

    I can make another table to hold the information I need but that would be redundant. I also tried exporting a view but that didnt work.

    any ideas?

  2. #2
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400

    export

    what do you mean by export functions

    why don't you make an temporary table.
    Will be deleted after transaction commit
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

  3. #3
    Join Date
    Apr 2002
    Location
    Calgary, Canada
    Posts
    30
    Thats what i am doing. But why create the added overhead of having to create a table, copy it to csv, then drop it when you can just select the columns you want to export and export them.

    it makes much more sense.

  4. #4
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400

    don't know

    I only know than you can export tables but I'm not sure

    I think I have done something but I think thats was the solution with the temp table
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

  5. #5
    Join Date
    Apr 2002
    Location
    Calgary, Canada
    Posts
    30
    Thanks anyways!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •