Re: [SQL] [GENERAL] pg_restore error - Any Idea?

2009-03-23 Thread Erik Jones
On Mar 22, 2009, at 10:44 PM, DM wrote: Hi All, I am facing an error on executing the below command dump name: pg_dump_FcZ0.pnps_200903041201_1.2.1.0_base_testing databae name: pnqd_test $pg_restore -U postgres -p 5433 -d pnqd_test pg_dump_FcZ0.pnps_200903041201_1.2.1.0_base_testing

Re: [SQL] bash postgres

2009-03-23 Thread Erik Jones
On Mar 22, 2009, at 9:03 PM, Greenhorn wrote: Hi, I'm trying to pass variables on a bash script embedded with psql commands. cat header.txt to1,from1,subject1 to2,from2,subject2 to3,from3,subject3 to4,from4,subject4 cat b.sh #!/bin/bash two=2 psql -h localhost -U postgres -d mobile -c

[SQL] cast bool/int

2009-03-23 Thread Zdravko Balorda
Hi, I need a casting operator from boolean to integer, tu put in ALTER TABLE statment after USING. Any ideas? Thanks. Zdravko -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql

Re: [SQL] cast bool/int

2009-03-23 Thread Achilleas Mantzios
Στις Monday 23 March 2009 09:59:12 ο/η Zdravko Balorda έγραψε: Hi, I need a casting operator from boolean to integer, tu put in ALTER TABLE statment after USING. How about CASE WHEN 't' THEN 1 ELSE 0 END Any ideas? Thanks. Zdravko -- Achilleas Mantzios -- Sent via pgsql-sql

Re: [SQL] cast bool/int

2009-03-23 Thread Achilleas Mantzios
Στις Monday 23 March 2009 09:59:12 ο/η Zdravko Balorda έγραψε: Hi, I need a casting operator from boolean to integer, tu put in ALTER TABLE statment after USING. Sorry in the above email i meant smth like CASE WHEN column='t' THEN 1 ELSE 0 END however SELECT 't'::boolean::int; int4

Re: [SQL] bash postgres

2009-03-23 Thread Tom Lane
Erik Jones ejo...@engineyard.com writes: On Mar 22, 2009, at 9:03 PM, Greenhorn wrote: How do I use \c (or any other psql commands beginning with a \) in a bash script? For multi-line input to a psql call in a bash (or any decent shell) script, I'd use a here document: Or echo/cat the

Re: [SQL] cast bool/int

2009-03-23 Thread Joshua Tolley
On Mon, Mar 23, 2009 at 10:18:31AM +0200, Achilleas Mantzios wrote: Στις Monday 23 March 2009 09:59:12 ο/η Zdravko Balorda έγραψε: Hi, I need a casting operator from boolean to integer, tu put in ALTER TABLE statment after USING. Sorry in the above email i meant smth like CASE

Re: [SQL] cast bool/int

2009-03-23 Thread Marcin Krawczyk
This: SELECT true::integer, false::integer also works on 8.1 -- regards mk 2009/3/23 Achilleas Mantzios ach...@matrix.gatewaynet.com Στις Monday 23 March 2009 09:59:12 ο/η Zdravko Balorda έγραψε: Hi, I need a casting operator from boolean to integer, tu put in ALTER TABLE statment

Re: [SQL] cast bool/int

2009-03-23 Thread Zdravko Balorda
CASE WHEN column='t' THEN 1 ELSE 0 END Or just CASE WHEN column THEN 1 ELSE 0 END. In the mean time I've got an elegant solution: alter ... ... column TYPE smallint USING column::boolean::int::smallint; It works, you wouldn't beleive it. ;) Zdravko -- Sent via pgsql-sql mailing list

Re: [SQL] [GENERAL] pg_restore error - Any Idea?

2009-03-23 Thread DM
Eric, There was no change in the version, we are using postgres v8.3.5 Thanks Deepak On Sun, Mar 22, 2009 at 11:17 PM, Erik Jones ejo...@engineyard.com wrote: On Mar 22, 2009, at 10:44 PM, DM wrote: Hi All, I am facing an error on executing the below command dump name:

Re: [GENERAL] [SQL] bash postgres

2009-03-23 Thread Erik Jones
On Mar 23, 2009, at 7:05 AM, Tom Lane wrote: Erik Jones ejo...@engineyard.com writes: On Mar 22, 2009, at 9:03 PM, Greenhorn wrote: How do I use \c (or any other psql commands beginning with a \) in a bash script? For multi-line input to a psql call in a bash (or any decent shell)

Re: [GENERAL] [SQL] bash postgres

2009-03-23 Thread Tom Lane
Erik Jones ejo...@engineyard.com writes: On Mar 23, 2009, at 7:05 AM, Tom Lane wrote: The reason you have to do this is that psql doesn't recognize backslash commands in a -c string. There's a school of thought that doesn't want us to allow multiple commands in a -c string, even. Hmm...