Hello,
I don't find in the PostgreSQL doc how to export a select result in a
text file.
Thanks if you can help me.
C. Tobini
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Hello,
I would like to know how to recuperate the results of a request.
I read the O'Reilly book about Postgresql and and know there are 2 ways
in PL/pgSQL to do that :
1.
declare
variable type;
select into variable column for table where...
2.
declare
variable table%ROWTYPE
for variable in sel
Hello,
I would like to know how to liste the contain of a fonction.
Writing \df in psql, I have a list of functions and triggers, but and
don't know how to obtain the code of those functions.
Thanks.
C. Tobini
---(end of broadcast)---
TIP 3: Hav
Hello,
I just installed postgresql 7.4 using Synaptic with Ubuntu Breezy
(i386) and I have a problem with my main Linux account.
I have created 3 users in postgresql: tobini (main), hadoc and postgres
(main postgresql account).
First using the postgres account I created 2 postgresql users for th
Hello,
I installed postgresql 7.4 on Ubuntu Breezy with libpq.dev and an error
occurs at postgres start (/etc/init.d/postgresql7.4 start) :
* Starting PostgreSQL 7.4 database server: main The PostgreSQL server
failed to start. Please check the log output:
/usr/lib/postgresql/7.4/bin/postmaster: T
I found how to make it run : the ' tcpip_socket ' must be changed to
true in /etc/postgresql/7.4/main/postgresql.conf.
C. Tobini
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Hello,
I have a problem with postgresql 7.4 installed on Linux Ubuntu 5.04
(hoary).
I made an 'alter' command for my db users :
eg: alter user postgres with password 'postgres';
ALTER USER
but I can't connect to postgresql using :
tobini% psql -d template1 -U postgres -W
password: postgres
psq
