Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I find out the create date of a table?

Status
Not open for further replies.
timfoster

timfoster

Programmer
Dec 19, 2002
110
GB
I'm from a SQL Server background, and this is the easiest thing in the world to do in SQL Server. In Postgres it seems to be much more difficult.

I want to find the date a table was created and/or last updated. This is in the schema in SQL Server, but I can't find anything remotely close in the Postgres infrmation schema. Perhaps I'm looking in the wrong places. Can someone point me in the right direction please?
 
Status
Not open for further replies.

Similar threads

wbower34
  • Locked
  • Question
Issues with table join
Replies
2
Views
153
wbower34
wbower34
wbower34
  • Locked
  • Question
sum hours fields into another table
Replies
0
Views
135
wbower34
wbower34
MCP2000
  • Locked
  • Question
Show records NOT BETWEEN date/timestamps
Replies
2
Views
201
MCP2000
MCP2000
OJSan
  • Locked
  • Question
On Postgresql 10 i can replace or rename the default Postgresql account?
Replies
0
Views
143
OJSan
OJSan
harfri
  • Locked
  • Question
Who can help me with a report in SQL
Replies
1
Views
144
feherke
feherke

Part and Inventory Search

Sponsor

Back
Top