> do $$
> begin
> execute 'COMMENT ON TABLE test_count is ''Updated ' || current_date ||
> ;
> end$$;
>
thanks, it works cool.
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-gener
On Nov 10, 2010, at 2:55 PM, pasman pasmański wrote:
> How to add comment on table with calculated value ?
>
> COMMENT ON TABLE test IS 'Updated ' || current_date;
You can create function to do that.
Or
If you are using PG9.0, then DO would help you, as given below:
do $$
Declare
t text;
be
2010/11/10 pasman pasmański
> Hello.
>
>
> How to add comment on table with calculated value ?
>
> COMMENT ON TABLE test IS 'Updated ' || current_date;
>
> not works ...
>
>
Hi,
I'd suggest something like this:
do $$
begin
execute 'COMMENT ON TABLE test_count is ''Updated ' || current_date ||
Hello.
How to add comment on table with calculated value ?
COMMENT ON TABLE test IS 'Updated ' || current_date;
not works ...
Regards.
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/ma
Michael Davis ha scritto:
How can I add a comment to a table, function, etc.
that will should up in a
/dd comment in psql?
pg_description has two fields...
joe=> \d pg_description
Table = pg_description
+--+--+---+
|
Michael -
I was just wondering this myself! I even dug into the source code, to
see if I could find how the comments get in there. Couldn't find any
existing SQL or psql command syntax, so I'm doing this:
template1=> \d pg_description
Table= pg_description
+-
How can I add a comment to a table, function, etc. that will should up in a
/dd comment in psql?
