Hi,
I am not sure what's your question.
However, you can list a bunch of SQL statements in a text file:
e.g.
myfile.sql which contains:
select * from tablename where
update tablename set ... where ...
.
then, you can just run it like:
psql -q dbname < myfile.sql
Jie LIANG
St. Be
I just put files commands that I want in some file
like "foo.sql" and then do:
psql mydatabase -f foo.sql
Is this what you are looking for?
Jason
--- Milen <[EMAIL PROTECTED]> wrote:
> Hi all!,
>
> I want to execute several SQL statements one after
> another.
> Does anyone know if it is pos
Hi all!,
I want to execute several SQL statements one after another.
Does anyone know if it is possible to create something like a "batch file"
which contains all SQL commands I want.
Best Regards:
Milen
---(end of broadcast)---
TIP 5: Have you c
i want to calculate the session time. my query is thisselect now()
- '2001-05-19 12:09:00+5;it gives the difference in date and difference
in time separately. if thecurrent time is greater than the second time then
it gives simply theirdifference but i want to calcutate the session time
f
I couldn't find the documentation for dealing with Large Objects on
the documentation. Any pointers?
The only info I found on Large Objects was on the programming guide,
but I'm not looking to write C functions with largo objects.
Thanks,
-Roberto
--
+| http:
Joachim Trinkwitz <[EMAIL PROTECTED]> writes:
> since some version hops, pg_dump created dump files won't be restored
> correctly anymore here. In a table I have an array which holds data in
> form of "x.y" values, where x are numbers and y either numbers or
> letters. An example for a field inclu
Dear all,
since some version hops, pg_dump created dump files won't be restored
correctly anymore here. In a table I have an array which holds data in
form of "x.y" values, where x are numbers and y either numbers or
letters. An example for a field including such an array is
{"1.2"}. After pg_dum
Hi,
I want know how we can insert values in the case where the type of column is
an othor table.
exemple:
CRETAE TABLE Address (Number integer, Street varchar, city varchar, contry
varchar);
CREATE TABLE Person (Name varchar, addr Address);
INSERT INTO addrerss VALUES ( 5, 'rue du pont', 'Lyon',
