Re: [GENERAL] \copy combine with SELECT
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 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 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
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, 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.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
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