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 Chris Miller 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
191
wbower34
wbower34
wbower34
  • Locked
  • Question
sum hours fields into another table
Replies
0
Views
163
wbower34
wbower34
MCP2000
  • Locked
  • Question
Show records NOT BETWEEN date/timestamps
Replies
2
Views
256
MCP2000
MCP2000
OJSan
  • Locked
  • Question
On Postgresql 10 i can replace or rename the default Postgresql account?
Replies
0
Views
176
OJSan
OJSan
harfri
  • Locked
  • Question
Who can help me with a report in SQL
Replies
1
Views
178
feherke
feherke

Part and Inventory Search

Sponsor

Back
Top