Re: [SQL] backup

On Wed, Jun 10, 2009 at 10:38 AM, Jyoti Seth wrote: > I tried using /copy command. It is not giving any error but also not > creating any file. > Thanks > Jyoti Use copy command as follows if the OS is Linux, postgres=# copy (select * from test where setid>20) to '/var/tmp/t2.dmp'; CO

Re: [SQL] backup

Thanks it worked when I changed the command '/copy' to '\copy' -Original Message- From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org] On Behalf Of Jasen Betts Sent: Tuesday, June 09, 2009 6:03 PM To: pgsql-sql@postgresql.org Subject: Re: [SQL] backup On 2009-06-09

Re: [SQL] backup

It should be \copy . This is a psql command; if you have direct access to database host machine, you might want to use the SQL command COPY for it's performance. http://www.postgresql.org/docs/8.3/interactive/app-psql.html http://www.postgresql.org/docs/8.3/interactive/sql-copy.html Best regards,

Re: [SQL] backup

I tried using /copy command. It is not giving any error but also not creating any file. Thanks Jyoti -Original Message- From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org] On Behalf Of Jasen Betts Sent: Tuesday, June 09, 2009 6:03 PM To: pgsql-sql@postgresql.org S

[SQL] Taking the cache out of the equation?

Caching helps a *lot* and I'm thankful for that but I would like to take it out of the picture as I massage my queries for better performance. Naturally the first invocation of the query cannot take advantage of the cache and these queries would normally only be called once for the same target

Re: [SQL] backup

On 2009-06-09, Jyoti Seth wrote: > This is a multipart message in MIME format. > > --=_NextPart_000_003C_01C9E916.43A8D460 > Content-Type: text/plain; > charset="us-ascii" > Content-Transfer-Encoding: 7bit > > Hi all, > > > > Can we take backup of specific data of a table (using where

Re: [SQL] backup

Jyoti Seth wrote: Hi all, Can we take backup of specific data of a table (using where clause)? Thanks, Jyoti Try Selective COPY With Regards Ashish Karalkar EnterpriseDB -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://w

[SQL] backup

Hi all, Can we take backup of specific data of a table (using where clause)? Thanks, Jyoti

[SQL] pg_restore

Hi all, I have two databases db1 and db2 with no network connection. I want to take backup of few master tables from db1 and restore it to db2 at frequent intervals.. I do not want to delete data from the tables and restores the fresh data as this data is getting referenced in other tables. I