unsubscribe
Now that's room service! Choose from over 150,000 hotels
in 45,000 destinations on Yahoo! Travel to find your fit.
http://farechase.yahoo.com/promo-generic-14795097
---(en
Osvaldo Rosario Kussama <[EMAIL PROTECTED]> writes:
>> |Does this mean the "filename" in COPY command can not be a variable?|
Got it in one.
You can use EXECUTE to put together commands that require a variable
in places where PG doesn't allow one.
regards, tom lane
-
Hi Steve,
Thanks for the alternative method, I will give that a try as well. It's nice
to know there is more than one road to reach a destination.
Thanks again,
Rommel Edwards
Software Developer,
Barbados, Caribbean.
---(end of broadcast)---
TIP 9
hongliu zou escreveu:
Am I forgetting some limitation?
I get " ERROR: syntax error at or near "$1"
SQL state: 42601 "with this
CREATE FUNCTION Import1() RETURNS text AS $$
DECLARE
path Char(100);
BEGIN
path = 'C:/zhl/hjs/anc_area.att';
COPY anc_areaAtt FRO
Hi Rommel,
I thought I'd throw a little more input in, as an alternative to psql.
I use Ruby on Rails with Postgres, and for testing, it drops the
testing database, recreates it and loads the structures dumped from the
development database, before running tests - to ensure a clean test
every
am Tue, dem 27.02.2007, um 9:48:57 -0300 mailte Ezequias Rodrigues da Rocha
folgendes:
> I understant you inquiry but I don't meant to add all the fields order
> in an insert statement.
>
> IE:
> insert into table values (value1, value2, value3)
>
> is better than
>
> insert into table (c
I understant you inquiry but I don't meant to add all the fields order
in an insert statement.
IE:
insert into table values (value1, value2, value3)
is better than
insert into table (column1,column2,column3 ...) values (value1,
value2, value3)
If there is only one way (recreating) that
am Tue, dem 27.02.2007, um 8:51:27 -0300 mailte Ezequias Rodrigues da Rocha
folgendes:
> Hi list,
>
> I just would like to know if it is possible to change the position of
> a field in a table. I am seen in pgAdmin3 that there is a position but
> on th is application I can't see if there is a p
Hi list,
I just would like to know if it is possible to change the position of
a field in a table. I am seen in pgAdmin3 that there is a position but
on th is application I can't see if there is a place to do that.
Regards
Ezequias
---(end of broadcast)--
