1
I have this script:
SELECT
n.nspname AS schema_name,
c.relname AS table_name,
c.reltuples::int AS num_reg
FROM pg_class c
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_tablespace t ON t.oid = c.reltablespace
WHERE c.relkind = 'r'::char
AND nspname NOT IN('information_schema','pg_catalog','pg_toast')
I want to add the letter’s' to the end of each table that returns the script in a Postgresql database. How to proceed? Could someone give an idea?
thank you very much! it worked
– leo Castro
blz @leoCastro, as solved your problem does not forget to mark as best answer. vlw!
– Camilo Santos