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

Re: [SQL] Exclude fields from SELECT command

no, there are no way regards Pavel Stehule Thanks for your time. Kind Regards Charles Workaround is create a view on that table excluding those 5 fields and then select * from that view . With regards Ashish Karalkar -- Sent via pgsql-sql mailing list (pgsql-sql

Re: [SQL] foreign key problem

- Original Message - From: "ivan marchesini" <[EMAIL PROTECTED]> To: Sent: Monday, September 24, 2007 6:04 PM Subject: [SQL] foreign key problem Dear users, I'm trying to create constraints into a db they give me from access... I'm using pgadmin to create a new foreign key for the r

Re: [SQL] How to use serial variable to insert into muiti-recrods?

I think default is a key word whic u r using as a column name in select statment. With Regards Ashish... - Original Message - From: "hu js" <[EMAIL PROTECTED]> To: Sent: Thursday, September 06, 2007 12:41 PM Subject: [SQL] How to use serial variable to insert into muiti-recrods?

Re: [SQL] List of FKeys ?

- Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Andreas" <[EMAIL PROTECTED]> Cc: Sent: Monday, August 27, 2007 9:18 AM Subject: Re: [SQL] List of FKeys ? Andreas <[EMAIL PROTECTED]> writes: could I get a list of foreign keys that refer to a column? The information_

[SQL] Birth Day Calculation

Hello All, I want to diplay all the name of persons who falls in between given day and month something like select name from my_table mt where mt.date_of_birth between 7-Jul and 15 - Aug column date_of_birth is of date type is there any way to do this Thanks in advance Ashish...

[SQL] Using case or if to return multiple rows

Hello all, I want to select data from two diffrent table based on third tables column somthing like: select case when t3.date='' then select * from table1 else select * from table 2 from table3 t3 where t3.date='x' Prob

[SQL] function to find difference between in days between two dates

ance With regards Ashish Karalkar

[SQL] sql server to postgreSQL

Hello All, I have a long list of sql server queries that needs to me remoulded in to postgres format can anyone please suggest me any tool that will convert sqlserver query into postgresql query except SwisSQL - SQLOne Console 3.0 Thanks in advance With regards Ashish Karalkar

Re: [SQL] need help

Anyone else is using this table simulteniously? With Regards Ashish... - Original Message - From: Penchalaiah P. To: pgsql-sql@postgresql.org Sent: Monday, May 14, 2007 12:20 PM Subject: [SQL] need help Hi . Create table cdano_nya(cdano int4,nyano int4) .