Re: [GENERAL] \copy combine with SELECT

[jia ding]

Thanks Martijn.

\d test
   Table public.test
 Column |  Type   | Modifiers
 id | integer |
 score| integer |

I tried \copy test (score) to test.txt. It works well.

But, suppose I want to select rows  with score  20 (just an example).
Then,\copy table [ ( column_list ) ] { from | to } filename  doesn't
help much.


Have a nice weekend!

N



On 3/17/06, Martijn van Oosterhout kleptog@svana.org wrote:
 On Fri, Mar 17, 2006 at 10:45:16AM +1100, Chris wrote:
  Doesn't look like \copy lets you specify which fields to include though.

 Ofcourse it does, you just need to use parenthesis. From the manpage:

 \copy table [ ( column_list ) ] { from | to } filename | stdin | stdout
 [ with ] [ oids ] [ delimiter [as]  'character' ] [ null [as]  'string' ]

 Have a nice day,
 --
 Martijn van Oosterhout   kleptog@svana.org   http://svana.org/kleptog/
  Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
  tool for doing 5% of the work and then sitting around waiting for someone
  else to do the other 95% so you can sue them.


 -BEGIN PGP SIGNATURE-
 Version: GnuPG v1.4.1 (GNU/Linux)

 iD8DBQFEGt++IB7bNG8LQkwRAvRlAJ9b3KJX82JviBnhTmexPa6nJlP2iACcD6gl
 5jLonNJA7sZpl1jxY+LQQ1E=
 =eepY
 -END PGP SIGNATURE-




---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] \copy combine with SELECT

[jia ding]

yes, of couse COPYbut,= copy test to 'test.txt';ERROR: must be superuser to COPY to or from a fileHINT: Anyone can COPY to stdout or from stdin. psql's \copy command also works for anyone.
On 3/16/06, Chris [EMAIL PROTECTED] wrote:
jia ding wrote: Hi all, I tried: select id, nameinto table2 from table1;\copy table2 to filename.txt in order to export 2 columns from table1 to a file. But, I am thinking, if there is a command can combine these two command
 together? Maybe, something like: \copy select id,namefrom tableto filename.txtClose.copy tablename field1, field2 to 'filename';
http://www.postgresql.org/docs/8.1/static/sql-copy.html--Postgresql  php tutorialshttp://www.designmagick.com/

[GENERAL] \copy combine with SELECT

[jia ding]

Hi all,I tried: select id, name into table2  from table1;\copy table2 to filename.txt in order to export 2 columns from table1 to a file.But, I am thinking, if there is a command can combine these two command together?
Maybe, something like: \copy select id,name from table to filename.txt ?Nina