hello
i am selecting ten fields form a table and i want to replace the null
values with any other value.
plz. help me
Ashok
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/F
hello
how i recognize the data type of any field
except \d table_name;
there is a function of libpq library for recognize field type
but it returns a number not a name of the data type so how i know the
name with the help of this number.
recv_interger_number = PQftype(resultant_pointer,field_n
On Tue, 2003-12-30 at 14:04, A.Bhuvaneswaran wrote:
> > A command for remove the column but it not work
> > it gives parse error
> > ALTER TABLE tablename DROP COLUMN fieldname;
>
> drop column feature is implemented since 7.3. So, you please check out
> your version.
>
> regards,
> bhuvaneswaran
hello
i have a problem to drop a column.
on postgresql site (link)
http://www.postgresql.org/docs/current/interactive/ddl-alter.html#AEN2124
A command for remove the column but it not work
it gives parse error
ALTER TABLE tablename DROP COLUMN fieldname;
plz. help me
Ashok
--
hello
in postgresql there is any system variable for update
Means if i update a record so any system variable store the
timestamp(update time) of that updated record.
Thankyou
Ashok
---(end of broadcast)---
TIP 7: don't forget to increase your fr
# include
# include
# include
int main()
{
PGresult *result;
PGconn *conn;
int feild;
printf("successful");
conn = PQconnectdb ("ashok");
result = PQexec (conn, "select * from bill");
feild = PQntuples (result
hi
*
# include
# include
# include
# include
int main()
{
PGresult *result;
PGconn *conn;
int feild;
conn = PQconnectdb ("ashok");
result = PQexec (conn, "select * from bill");
feild = PQntuples (result);
p
hi
there is any command to see the timestamp of any record that is stored
in a table already.
Except that add a field of timestamp type in that table.
plz help me.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
hi
In postgresql any mechanism for store insert & update queries of a
particular database.
so that after sometime i can use those queries.
plz help me.
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if y
hi
In postgresql all databases are stored in /data/base directory in
numbers form and all the related tables with that database are stored in
that directory again in numbers form.
so there is any command or query to see the original table names.
just like:- select * from pg_stat_database; for da
hi
In postgresql all databases are stored in /data/base directory in
numbers form and all the related tables with that database are stored in
that directory again in numbers form.
so there is any command or query to see the original table names.
just like:- select * from pg_stat_database; for d
hi
In postgresql all databases are stored in /data/base directory in
numbers form and all the related tables with that database are stored in
that directory again in numbers form.
so there is any command or query to see the original table names.
just like:- select * from pg_stat_database; for d
hi
i want to accsess my postgresql data base from network it is only
possible when i start postgresql by following command:-
postmaster -i -D /var/lib/pgsql/data
after rebooting the system it does not listen for TCP/IP connection.
how can i configure it for listening TCP/IP connection after reboot
hi
i am a new user in postgresql.
problem:- in postgresql there is any command to see history (previous
day queries) like as history command in linux.
thank you
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister c
hi
there is any utility or command in postgresql for incremental backup or
incremental restore.
plz. help me.
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere"
hi;
i am trying to make a utility that is worked as database
synchronization.
there are 5 offices in different states and all they use same database
means (same structure table).
there is a head office where is central server that is maintained all
offices databases seprately.
now i think follow
# include
# include
int main()
{
int feild;
PGresult *result;
PGconn *conn;
conn = PQconnectdb("database");
result = PQexec (conn, "select * from teblename");
feild = PQntuples (result);
printf("%d",feild);
PQclear(result);
help me
i re - install the postgresql but it not start, gives following errors:
1) initiliazing database [FAILED]
2) postgresql service [FAILED]
it gives a message in /var/log/message:- "session closed for user
postgres"
pls help me.
-
there is any utility or command for compare two databases,
tables structure (schema).
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
after login into pgsql through a user, when i try to connect some other
database it always says that permission denied.
what do i do?
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
we have made 4 databases in postgresql, now we want to know how can be
recognize these database files in /var/lib/pgsql/data/base.
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/fa
>>If I do any changes in pg_hba.conf file do I need restart pgsql.
>>The changes I made does not taking effect.
>>ganesh
Yes, you need to restart pgsql.
the changes you made it does not effect.
but also my suggestion is that to perform any changes in pg_hba.conf or
any pgsql configration file ,
22 matches
Mail list logo
