Re: Flat File unload/export/copy
От | Steve T |
---|---|
Тема | Re: Flat File unload/export/copy |
Дата | |
Msg-id | 1221239682.3603.209.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Flat File unload/export/copy (Steve T <steve@retsol.co.uk>) |
Список | pgsql-novice |
Sean,
8.1.10 - I read the docs first (which is a first for me!) before I posted and couldn't see a 'specific' data based row unload. I suppose I can always simply execute the sql and re-direct the output to a file (that just crossed my mind) - I'll try that tomorrow (I think I can unset headings in psql as well - so that will give me a pseudo 'unload/copy' file I think)
On Fri, 2008-09-12 at 12:20 -0400, Sean Davis wrote:
8.1.10 - I read the docs first (which is a first for me!) before I posted and couldn't see a 'specific' data based row unload. I suppose I can always simply execute the sql and re-direct the output to a file (that just crossed my mind) - I'll try that tomorrow (I think I can unset headings in psql as well - so that will give me a pseudo 'unload/copy' file I think)
On Fri, 2008-09-12 at 12:20 -0400, Sean Davis wrote:
On Fri, Sep 12, 2008 at 12:10 PM, Steve T <steve@retsol.co.uk> wrote: > Regina, > I wasn't aware that you could! > I just tried and that syntax gave me an error: > rel_reinsure=# copy (select * from client where name like '%BERT%') to > '/tmp/stevet.clients'; > ERROR: syntax error at or near "(" at character 6 > LINE 1: copy (select * from client where name like '%BERT%') to '/tm... > > - I can do though: > rel_reinsure=# copy client (recno,code,name) to '/tmp/stevet.clients'; > > ... or select all columns, but that is 'too global' and I just want 'WHERE > name LIKE '%BERT%' type syntax. What version of Postgres are you using? The docs for the version can give you an idea about syntax. Sean > > On Fri, 2008-09-12 at 11:31 -0400, Obe, Regina wrote: > > And why can't you use copy? > > Something like below - > > COPY (SELECT * FROM sometable WHERE somevalue LIKE '%') TO > '/path/to/textfile.csv' > > WITH NULL As 'NULL' CSV HEADER QUOTE AS '"'; > > > > > ________________________________ > > From: pgsql-novice-owner@postgresql.org > [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Steve T > Sent: Friday, September 12, 2008 11:16 AM > To: PostGreSQL > Subject: [NOVICE] Flat File unload/export/copy > > > Is there a command that copies data from a table to a flat file for > specified selection criteria? > IE akin to a copy but not dumping a whole file? > If I'm about to do a major change to data in a table, I'd like to be > able to keep a copy of the data before the change (I know I can > Begin...rollback should things go wrong). > > Is there a command that I've missed? (Informix had an 'UNLOAD TO blah > SELECT blah..' type command which presumably was proprietary). > ----------------------------------------- > The substance of this message, including any attachments, may be > confidential, legally privileged and/or exempt from disclosure > pursuant to Massachusetts law. It is intended > solely for the addressee. If you received this in error, please > contact the sender and delete the material from any computer. > > > > > Steve Tucknott > ReTSol Ltd > > DDI: 01323 488548 > Mobile: 0773 671 5772
|
В списке pgsql-novice по дате отправления: