Answer / Gaurav Bhatt

To find the creation date of a table in PostgreSQL, you can use the ``psql`" command-line tool and run the following query: ``SELECT tablename, tableattribs->'table_catalog' AS catalog,n tableattribs->'table_schema' AS schema,n tableattribs->'table_name' AS tablename,n pg_get_table_def(tablename) AS definitionnFROM pg_catalog.pg_tables,n (SELECT relname, tablename FROM pg_catalog.pg_depend WHERE objid = OBJECT_ID('public.your_table')) AS tableattribs`". The creation date should be visible in the table definition.

What is the default postgres database?

1 Answers  

---

What is difference between drop and delete?

1 Answers  

---

What is sequences in postgresql?

1 Answers  

---

Is postgresql a programming language?

1 Answers  

---

How to view tables in a database in postgresql?

1 Answers  

---

What is the advantage of postgresql?

1 Answers  

---

How to created a database?

1 Answers  

---

What is a ctid?

1 Answers  

---

What is psql command?

1 Answers  

---

How do I change the default postgres password?

1 Answers  

---

How do I connect to postgresql access?

1 Answers  

---

when will data in the data base is updated

3 Answers   IEG,

---