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
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
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
Στις 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
Στις 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
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
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
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
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
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:
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)
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...
12 matches
Mail list logo